https://bz.apache.org/bugzilla/show_bug.cgi?id=65077
Andrey Grigoriev <[email protected]> changed: What |Removed |Added ---------------------------------------------------------------------------- OS| |All --- Comment #1 from Andrey Grigoriev <[email protected]> --- There was wrong example. Please use this one: int rowNumber = 0; int cellNumber = 0; String outputFileName = "c:/temp/test1.xlsx"; File outFile = new File(outputFileName); //File outFile2 = new File("c:/temp/test2.xlsx"); Workbook workbook = new SXSSFWorkbook(100); try { Sheet sheet = workbook.createSheet("Sheet1"); Row row = null; for (int i = 0; i < 1000; i++) { row = sheet.createRow(rowNumber++); cellNumber = 0; for (int j = 1; j <= 10; j++) { Cell cell = row.createCell(cellNumber++); cell.setCellValue(String.valueOf(j)); } } try (FileOutputStream out = new FileOutputStream(outFile)) { workbook.write(out); } } finally { workbook.close(); ((SXSSFWorkbook) workbook).dispose(); } rowNumber = 0; cellNumber = 0; workbook = new SXSSFWorkbook((XSSFWorkbook) WorkbookFactory.create(outFile), 100); try { Sheet sheet = workbook.createSheet("Sheet2"); Row row = null; for (int i = 0; i < 1000; i++) { row = sheet.createRow(rowNumber++); cellNumber = 0; for (int j = 1; j <= 10; j++) { Cell cell = row.createCell(cellNumber++); cell.setCellValue(String.valueOf(j)); } } Files.delete(Paths.get(outFile.getPath())); try (FileOutputStream out = new FileOutputStream(outFile)) { workbook.write(out); } } finally { workbook.close(); ((SXSSFWorkbook) workbook).dispose(); } -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
