Package org.apache.poi.ss.usermodel

Examples of org.apache.poi.ss.usermodel.Workbook.createSheet()

147
148
149
150
151
152
153
154
155
156
157
    private static File createSpreadsheet(boolean xml) {

        final Workbook wb = xml ? new XSSFWorkbook() : new HSSFWorkbook();

        for (int s = 0; s < SHEETS; s++) {
            Sheet sheet = wb.createSheet("Test Sheet " + s);

            for (int row = 0; row < ROWS; row++) {
                int col = 0;
                Row r = sheet.createRow(row);
                Cell c;
View Full Code Here
78
79
80
81
82
83
84
85
86
87
88
            int rowCount = 0;
            CellStyle dateStyle;
           
            @Override
            public void startFile(JSONObject options) {
                s = wb.createSheet();
                String sheetName = WorkbookUtil.createSafeSheetName(
                        ProjectManager.singleton.getProjectMetadata(project.id).getName());
                wb.setSheetName(0, sheetName);

                dateStyle = wb.createCellStyle();
View Full Code Here
66
67
68
69
70
71
72
73
74
75
76
   * @throws JSONException
   */
  public Workbook export(JSONObject json) throws JSONException {
   
    Workbook wb = new HSSFWorkbook();
    Sheet sheet = wb.createSheet("new sheet");
    CreationHelper createHelper = wb.getCreationHelper();
      fillSheet(sheet, json, createHelper);   
    return wb;
  }
 
View Full Code Here
55
56
57
58
59
60
61
62
63
64
65
  }
 
  public Workbook exportInExcel(){
    Workbook wb = new HSSFWorkbook();
      CreationHelper createHelper = wb.getCreationHelper();
      Sheet sheet = wb.createSheet("new sheet");
      for(int j = 0; j < 50; j++){
      sheet.createRow(j);
    }
      fillSheet(sheet, wb, createHelper);
View Full Code Here
399
400
401
402
403
404
405
406
407
408
409
     *  be doing... Someone who understands the goals a little
     *  better should really review this!
     */
    public void testSetColumnGroupCollapsed(){
        Workbook wb = new XSSFWorkbook();
        XSSFSheet sheet1 =(XSSFSheet) wb.createSheet();

        CTCols cols=sheet1.getCTWorksheet().getColsArray(0);
        assertEquals(0,cols.sizeOfColArray());

        sheet1.groupColumn( (short)4, (short)7 );
View Full Code Here
629
630
631
632
633
634
635
636
637
638
639
     *  be doing... Someone who understands the goals a little
     *  better should really review this!
     */
    public void testSetRowGroupCollapsed(){
        Workbook wb = new XSSFWorkbook();
        XSSFSheet sheet1 = (XSSFSheet)wb.createSheet();

        sheet1.groupRow( 5, 14 );
        sheet1.groupRow( 7, 14 );
        sheet1.groupRow( 16, 19 );

View Full Code Here
64
65
66
67
68
69
70
71
72
73
74
        return createCell(0, 0, aDouble);
    }

        static Cell createCell(int row, int column, Date date) {
        Workbook workbook = new HSSFWorkbook();
        Sheet sheet = workbook.createSheet();
        Cell cell = sheet.createRow(row).createCell(column, CELL_TYPE_NUMERIC);
        cell.setCellValue(date);
        CellStyle style = workbook.createCellStyle();
        style.setDataFormat(workbook.getCreationHelper().createDataFormat().getFormat("m/d/yy h:mm"));
        cell.setCellStyle(style);
View Full Code Here
85
86
87
88
89
90
91
92
93
94
95
        return createCell(0, 0, value);
    }

    private static Cell create(int row, int column, int type) {
        Workbook workbook = new HSSFWorkbook();
        Sheet sheet = workbook.createSheet();
        Cell cell = sheet.createRow(row).createCell(column, type);
        return cell;
    }

}
View Full Code Here
60
61
62
63
64
65
66
67
68
69
70
        new HSSFWorkbook(), new XSSFWorkbook()
    };
   
    for (int i = 0; i < wbs.length; i++) {
      Workbook wb = wbs[i];
        Sheet sheet1 = wb.createSheet("new sheet");
        Sheet sheet2 = wb.createSheet("second sheet");
        FileOutputStream fileOut = new FileOutputStream("workbook.xls");
        wb.write(fileOut);
        fileOut.close();
    }
View Full Code Here
61
62
63
64
65
66
67
68
69
70
71
    };
   
    for (int i = 0; i < wbs.length; i++) {
      Workbook wb = wbs[i];
        Sheet sheet1 = wb.createSheet("new sheet");
        Sheet sheet2 = wb.createSheet("second sheet");
        FileOutputStream fileOut = new FileOutputStream("workbook.xls");
        wb.write(fileOut);
        fileOut.close();
    }
  }
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
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.