Package org.apache.poi.ss.usermodel

Examples of org.apache.poi.ss.usermodel.Workbook

50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
        verifyResource("test2-workbook.xls");
    }

    private void verifyResource(String resource) throws IOException {
        final InputStream document = this.getClass().getResourceAsStream(resource);
        final Workbook wb;
        if(resource.endsWith(".xlsx")) {
            wb = new XSSFWorkbook(document);
        } else if(resource.endsWith("xls")) {
            wb = new HSSFWorkbook(document);
        } else {
            throw new IllegalArgumentException("Unsupported extension for resource " + resource);
        }
        Assert.assertEquals(2, wb.getNumberOfSheets());
        Sheet sheet;
        for (int sheetIndex = 0; sheetIndex < wb.getNumberOfSheets(); sheetIndex++) {
            sheet = wb.getSheetAt(sheetIndex);
            int rowcount = 0;
            for (Row row : sheet) {
                rowcount++;
                int cellcount = 0;
                for (Cell cell : row) {
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
     * @return  the width in pixels
     */
    public static double getCellWidth(Cell cell, int defaultCharWidth, DataFormatter formatter, boolean useMergedCells) {

        Sheet sheet = cell.getSheet();
        Workbook wb = sheet.getWorkbook();
        Row row = cell.getRow();
        int column = cell.getColumnIndex();

        int colspan = 1;
        for (int i = 0 ; i < sheet.getNumMergedRegions(); i++) {
            CellRangeAddress region = sheet.getMergedRegion(i);
            if (containsCell(region, row.getRowNum(), column)) {
                if (!useMergedCells) {
                    // If we're not using merged cells, skip this one and move on to the next.
                    return -1;
                }
                cell = row.getCell(region.getFirstColumn());
                colspan = 1 + region.getLastColumn() - region.getFirstColumn();
            }
        }

        CellStyle style = cell.getCellStyle();
        int cellType = cell.getCellType();

        // for formula cells we compute the cell width for the cached formula result
        if(cellType == Cell.CELL_TYPE_FORMULA) cellType = cell.getCachedFormulaResultType();

        Font font = wb.getFontAt(style.getFontIndex());

        AttributedString str;
        TextLayout layout;

        double width = -1;
View Full Code Here
207
208
209
210
211
212
213
214
215
216
217
218
219
     */
    public static double getColumnWidth(Sheet sheet, int column, boolean useMergedCells){
        AttributedString str;
        TextLayout layout;

        Workbook wb = sheet.getWorkbook();
        DataFormatter formatter = new DataFormatter();
        Font defaultFont = wb.getFontAt((short) 0);

        str = new AttributedString(String.valueOf(defaultChar));
        copyAttributes(defaultFont, str, 0, 1);
        layout = new TextLayout(str.getIterator(), fontRenderContext);
        int defaultCharWidth = (int)layout.getAdvance();
View Full Code Here
244
245
246
247
248
249
250
251
252
253
254
255
256
     */
    public static double getColumnWidth(Sheet sheet, int column, boolean useMergedCells, int firstRow, int lastRow){
        AttributedString str;
        TextLayout layout;

        Workbook wb = sheet.getWorkbook();
        DataFormatter formatter = new DataFormatter();
        Font defaultFont = wb.getFontAt((short) 0);

        str = new AttributedString(String.valueOf(defaultChar));
        copyAttributes(defaultFont, str, 0, 1);
        layout = new TextLayout(str.getIterator(), fontRenderContext);
        int defaultCharWidth = (int)layout.getAdvance();
View Full Code Here
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
import org.apache.poi.util.TempFile;

public final class TestDateFormatConverter extends TestCase {
    private void outputLocaleDataFormats( Date date, boolean dates, boolean times, int style, String styleName ) throws Exception {

        Workbook workbook = new HSSFWorkbook();
        String sheetName;
        if( dates ) {
            if( times ) {
                sheetName = "DateTimes";
            } else {
                sheetName = "Dates";
            }
        } else {
            sheetName = "Times";
        }
        Sheet sheet = workbook.createSheet(sheetName);
        Row header = sheet.createRow(0);
        header.createCell(0).setCellValue("locale");
        header.createCell(1).setCellValue("DisplayName");
        header.createCell(2).setCellValue("Excel " + styleName);
        header.createCell(3).setCellValue("java.text.DateFormat");
        header.createCell(4).setCellValue("Equals");
        header.createCell(5).setCellValue("Java pattern");
        header.createCell(6).setCellValue("Excel pattern");

        int rowNum = 1;
        for( Locale locale : DateFormat.getAvailableLocales() ) {
            try {
                Row row = sheet.createRow(rowNum++);
   
                row.createCell(0).setCellValue(locale.toString());
                row.createCell(1).setCellValue(locale.getDisplayName());
   
                DateFormat dateFormat;
                if( dates ) {
                    if( times ) {
                        dateFormat = DateFormat.getDateTimeInstance(style, style, locale);
                    } else {
                        dateFormat = DateFormat.getDateInstance(style, locale);
                    }
                } else {
                    dateFormat = DateFormat.getTimeInstance(style, locale);
                }
   
                Cell cell = row.createCell(2);
   
                cell.setCellValue(date);
                CellStyle cellStyle = row.getSheet().getWorkbook().createCellStyle();
   
                String javaDateFormatPattern = ((SimpleDateFormat)dateFormat).toPattern();
                String excelFormatPattern = DateFormatConverter.convert(locale, javaDateFormatPattern);
   
                DataFormat poiFormat = row.getSheet().getWorkbook().createDataFormat();
                cellStyle.setDataFormat(poiFormat.getFormat(excelFormatPattern));
                row.createCell(3).setCellValue(dateFormat.format(date));
   
                cell.setCellStyle(cellStyle);
   
                // the formula returns TRUE is the formatted date in column C equals to the string in column D
                row.createCell(4).setCellFormula("TEXT(C"+rowNum+",G"+rowNum+")=D" + rowNum);
                row.createCell(5).setCellValue(javaDateFormatPattern);
                row.createCell(6).setCellValue(excelFormatPattern);
            } catch (Exception e) {
                throw new RuntimeException("Failed for locale: " + locale + ", having locales: " +
                        Arrays.toString(DateFormat.getAvailableLocales()), e);
            }
        }

        File outputFile = TempFile.createTempFile("Locale" + sheetName + styleName, ".xlsx");
        FileOutputStream outputStream = new FileOutputStream(outputFile);
        try {
            workbook.write(outputStream);
        } finally {
            outputStream.close();
        }

        System.out.println("Open " + outputFile.getAbsolutePath()+" in Excel");
View Full Code Here
96
97
98
99
100
101
102
103
104
105
106
    }
    log( versionBffr.toString(), Project.MSG_INFO ) ;
   
    log( "Using input file: " + excelFileName, Project.MSG_INFO ) ;
   
    Workbook targetWorkbook = loadWorkbook() ;
    if( targetWorkbook == null ) {
      log( "Unable to load " + excelFileName +
                      ".  Verify the file exists and can be read.",
                      Project.MSG_ERR ) ;
      return ;
View Full Code Here
65
66
67
68
69
70
71
72
73
74
75
  }
 
  public void testWorkbookConstructor() throws InvalidFormatException, IOException {
        File workbookFile = new File(mortgageCalculatorFileName);
        FileInputStream fis = new FileInputStream(workbookFile);
        Workbook workbook = WorkbookFactory.create(fis);

    fixture = new ExcelAntWorkbookUtilTestHelper( workbook ) ;
   
    assertNotNull( fixture ) ;
   
View Full Code Here
92
93
94
95
96
97
98
99
100
    fixture = new ExcelAntWorkbookUtilTestHelper(
                mortgageCalculatorFileName ) ;
   
    assertNotNull( fixture ) ;
   
    Workbook workbook = fixture.getWorkbook() ;
   
    assertNotNull( workbook ) ;
  }
View Full Code Here
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
            System.err.println("Use:");
            System.err.println("  CheckFunctionsSupported <filename>");
            return;
        }
       
        Workbook wb = WorkbookFactory.create(new File(args[0]));
        CheckFunctionsSupported check = new CheckFunctionsSupported(wb);
       
        // Fetch all the problems
        List<FormulaEvaluationProblems> problems = new ArrayList<CheckFunctionsSupported.FormulaEvaluationProblems>();
        for (int sn=0; sn<wb.getNumberOfSheets(); sn++) {
            problems.add(check.getEvaluationProblems(sn));
        }
       
        // Produce an overall summary
        Set<String> unsupportedFunctions = new TreeSet<String>();
        for (FormulaEvaluationProblems p : problems) {
            unsupportedFunctions.addAll(p.unsupportedFunctions);
        }
        if (unsupportedFunctions.isEmpty()) {
            System.out.println("There are no unsupported formula functions used");
        } else {
            System.out.println("Unsupported formula functions:");
            for (String function : unsupportedFunctions) {
                System.out.println("  " + function);
            }
            System.out.println("Total unsupported functions = " + unsupportedFunctions.size());
        }
       
        // Report sheet by sheet
        for (int sn=0; sn<wb.getNumberOfSheets(); sn++) {
            String sheetName = wb.getSheetName(sn);
            FormulaEvaluationProblems probs = problems.get(sn);
           
            System.out.println();
            System.out.println("Sheet = " + sheetName);
           
View Full Code Here
2437
2438
2439
2440
2441
2442
2443
2444
2445
2446
2447
2448
2449
2450
2451
2452
2453
2454
        assertNotNull(sh2.getDrawingPatriarch());
    }

    @Test
    public void bug53432(){
        Workbook wb = new HSSFWorkbook(); //or new HSSFWorkbook();
        wb.addPicture(new byte[]{123,22}, Workbook.PICTURE_TYPE_JPEG);
        assertEquals(wb.getAllPictures().size(), 1);

        wb = new HSSFWorkbook();
        wb = writeOutAndReadBack((HSSFWorkbook) wb);
        assertEquals(wb.getAllPictures().size(), 0);
        wb.addPicture(new byte[]{123,22}, Workbook.PICTURE_TYPE_JPEG);
        assertEquals(wb.getAllPictures().size(), 1);

        wb = writeOutAndReadBack((HSSFWorkbook) wb);
        assertEquals(wb.getAllPictures().size(), 1);
    }
View Full Code Here
TOP

Related Classes of org.apache.poi.ss.usermodel.Workbook

  • accounts.web.ReportPoiController
  • accounts.web.ReportPoiControllerTest
  • bad.robot.excel.matchers.StubCell
  • br.com.objectos.comuns.io.xls.XlsFile
  • br.com.objectos.way.io.TableStyle
  • br.com.objectos.way.io.WayIO
  • br.com.objectos.way.io.WorkbookXlsApachePOI
  • br.net.woodstock.rockframework.office.spreadsheet.poi.AbstractSpreadsheetDocumentReader
  • com.asakusafw.testdata.generator.excel.MainTest
  • com.asakusafw.testdata.generator.excel.SheetBuilderTest
    • Copyright © 2018 www.massapicom. 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.