List of createSheet() Examples

Examples of createSheet()

com.trulytech.mantis.util.ExcelWriter.createSheet()
jxl.write.WritableWorkbook.createSheet()
Creates, and returns a worksheet at the specified position with the specified name If the index specified is less than or equal to zero, the new sheet is created at the beginning of the workbook. If the index is greater than the number of sheet, then the sheet is created at the end of the workbook. @param name the sheet name @param index the index number at which to insert @return the new sheet
org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet()
create an HSSFSheet for this HSSFWorkbook, adds it to the sheets and returns the high level representation. Use this to create new sheets. @return HSSFSheet representing the new sheet.
org.apache.poi.ss.usermodel.Workbook.createSheet()
Sreate an Sheet for this Workbook, adds it to the sheets and returns the high level representation. Use this to create new sheets. @return Sheet representing the new sheet.
org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet()
Sreate an Sheet for this Workbook, adds it to the sheets and returns the high level representation. Use this to create new sheets. @return Sheet representing the new sheet.
org.apache.poi.xssf.usermodel.XSSFWorkbook.createSheet()
Create an XSSFSheet for this workbook, adds it to the sheets and returns the high level representation. Use this to create new sheets. @return XSSFSheet representing the new sheet.
org.zkoss.zss.model.Book.createSheet()

Examples of com.trulytech.mantis.util.ExcelWriter.createSheet()

    response.setContentType("application/msexcel");
      response.setHeader("Content-Disposition", " filename=report.xls");
      
      ServletOutputStream ouputStream = response.getOutputStream();
      ExcelWriter writer = new ExcelWriter(ouputStream);
      writer.createSheet("信息表", 0);
      
      writer.mergeCells(0, 0, 0, 14, 0);
      
      WritableFont font = new WritableFont(WritableFont.ARIAL, 16,
                WritableFont.BOLD, false,

View Full Code Here

Examples of jxl.write.WritableWorkbook.createSheet()


   private boolean writeXLS(File file, boolean includeHeaders, int nbrSelCols, int[] selCols, int nbrSelRows, TableExportCsvController ctrl, int[] selRows)
      throws IOException, WriteException
   {
      WritableWorkbook workbook = Workbook.createWorkbook(file);
      WritableSheet sheet = workbook.createSheet("Squirrel SQL Export", 0);




      int curRow= 0;
      if (includeHeaders)
      {

View Full Code Here

Examples of jxl.write.WritableWorkbook.createSheet()

                SummaryStatBean.StatDataBean statDataBean = statdetails
                        .getData().get(0);


                if (changedType)
                {
                    sheet = workbook.createSheet(I18nUtil.getMessage("it.cilea.hku.statistics.Subscribe.sheet." + statdetails.getType()),
                            sheetNumber);
                    WritableFont labelFont = new WritableFont(
                            WritableFont.ARIAL, 10, WritableFont.BOLD);
                    WritableCellFormat cfobj = new WritableCellFormat(labelFont);
                    sheet.addCell(new Label(

View Full Code Here

Examples of jxl.write.WritableWorkbook.createSheet()

            IllegalArgumentException, IllegalAccessException,
            InvocationTargetException
    {


        WritableWorkbook workbook = Workbook.createWorkbook(os);
        WritableSheet sheet = workbook.createSheet("Sheet", 0);


        // create initial caption (other caption could be write field together)
        int x = 0;
        sheet.addCell(new Label(x++, 0, "staffNo"));
        sheet.addCell(new Label(x++, 0, "rp"));

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet()

import org.apache.poi.ss.usermodel.DataFormat;


public class PoiTest {
  public static void main(String[] args) throws IOException {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("new sheet");


    // Create a row and put some cells in it. Rows are 0 based.
    HSSFRow row = sheet.createRow(0);


    // Create a cell and put a date value in it. The first cell is not

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet()

        Preferences coreStore = BrowserCorePlugin.getDefault().getPluginPreferences();
        String valueDelimiter = coreStore.getString( BrowserCoreConstants.PREFERENCE_FORMAT_XLS_VALUEDELIMITER );
        int binaryEncoding = coreStore.getInt( BrowserCoreConstants.PREFERENCE_FORMAT_XLS_BINARYENCODING );


        HSSFWorkbook wb = new HSSFWorkbook();
        HSSFSheet sheet = wb.createSheet( "Export" ); //$NON-NLS-1$


        // header
        HSSFRow headerRow = sheet.createRow( 0 );
        LinkedHashMap<String, Short> attributeNameMap = new LinkedHashMap<String, Short>();
        if ( this.exportDn )

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet()

   * This test makes sure that any {@link MissingArgEval} that propagates to
   * the result of a function gets translated to {@link BlankEval}.
   */
  public void testMissingArg() {
    HSSFWorkbook wb = new HSSFWorkbook();
    HSSFSheet sheet = wb.createSheet("Sheet1");
    HSSFRow row = sheet.createRow(0);
    HSSFCell cell = row.createCell(0);
    cell.setCellFormula("1+IF(1,,)");
    HSSFFormulaEvaluator fe = new HSSFFormulaEvaluator(wb);
    CellValue cv;

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet()

  @Override
  public void processExport(OutputStream output) {


    try {
      HSSFWorkbook workbook = new HSSFWorkbook();
      HSSFSheet sheet = workbook.createSheet(exportConf.getFileName());
      Row row = null;
      Cell cell = null;
      int rowIndex = 0;
      int columnIndex;

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet()

      
    Workbook workbook = new HSSFWorkbook();
      
    for (int cnt=0; cnt<tests.size(); cnt++) {
      setColumns(tests.get(cnt));
      Sheet sheet = workbook.createSheet("Test " + cnt);
      Row row = sheet.createRow(0);


      int counter = 2; //A counter which is used to determine how many additional columns are needed.
      createCell(workbook, row, 0, "Grupa", CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER);
      createCell(workbook, row, 1, "Indeks", CellStyle.ALIGN_CENTER, CellStyle.VERTICAL_CENTER);

View Full Code Here

Examples of org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet()

        return fileName;
    }


    public void performExport(DataExportModel model, DataExportInstructions instructions, ConnectionHandler connectionHandler) throws DataExportException {
        HSSFWorkbook workbook = new HSSFWorkbook();
        HSSFSheet sheet = workbook.createSheet(model.getTableName());


        if (instructions.createHeader()) {
            HSSFRow headerRow = sheet.createRow(0);


            for (int columnIndex = 0; columnIndex < model.getColumnCount(); columnIndex++){

View Full Code Here

0 1 2 3 4 5

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.