| Summary: | DeferredSXSSFWorkboot not working cellStyle | ||
|---|---|---|---|
| Product: | POI | Reporter: | silver0r <silver0r> |
| Component: | SXSSF | Assignee: | POI Developers List <dev> |
| Status: | RESOLVED INFORMATIONPROVIDED | ||
| Severity: | major | ||
| Priority: | P2 | ||
| Version: | unspecified | ||
| Target Milestone: | --- | ||
| Hardware: | PC | ||
| OS: | Mac OS X 10.1 | ||
the row generator is designed for generating rows - can you create the style outside the row generator function? (In reply to PJ Fanning from comment #1) > the row generator is designed for generating rows - can you create the style > outside the row generator function? TYSM your comment How can I create the cell style outside the row generator? It would be of great help if you could provide a simple example. and I have question. Can I make multiple row generator function in one xlsx file? TYSM I have updated the example at https://github.com/apache/poi/blob/trunk/poi-examples/src/main/java/org/apache/poi/examples/xssf/streaming/DeferredGeneration.java to show the cell style creation. You can only add 1 row generator per sheet. (In reply to PJ Fanning from comment #3) > I have updated the example at > https://github.com/apache/poi/blob/trunk/poi-examples/src/main/java/org/ > apache/poi/examples/xssf/streaming/DeferredGeneration.java to show the cell > style creation. You can only add 1 row generator per sheet. thanks for your kind I'll try it :) This is answered via an enhanced example as far as I see. |
Hello, PIO Team I heared Apache POI 5.0.0 version upgrade and apply DeferredSXSSFWorkbook. I really wanted this and it's powerful. When I apply DeferredSXSSFWorkbook, I found some bug. When applying a cellStyle based on DeferredSXSSFWorkbook, it's not working and an error occurs when the excel file is opened. (Also SXSSFWorkbook is working for me) DeferredSXSSFWorkbook workbook = new DeferredSXSSFWorkbook(500); DeferredSXSSFSheet deferredSXSSFSheet = workbook.createSheet(); deferredSXSSFSheet.setRowGenerator(sheet -> { Row row = sheet.createRow(0); Cell cell = row.createCell(0); CellStyle cellStyle = workbook.createCellStyle(); cellStyle.setAlignment(HorizontalAlignment.RIGHT); cell.setCellStyle(cellStyle); cell.setCellValue("test"); }); workbook.write(response.getOutputStream()); Could you check it? TYSM.