Export more than 65536 rows

ravindersinghblujay / tableexport-for-vaadin

Automatically exported from code.google.com/p/tableexport-for-vaadin

0 stars 2 forks source link

Export more than 65536 rows #27

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago

What steps will reproduce the problem?
1. Trying to export more than 655366 rows will throw an exception.

It'll be helpful if at least I can Split the table in parts, so It'll be 
exported in multiple files, I'm working with 230000+ rows...

Original issue reported on code.google.com by jgama...@jarris.com.co on 3 Aug 2012 at 4:20

GoogleCodeExporter commented 9 years ago

Old binary .xls format doesn't support more than 65545 rows. 
You have to use new Excel 2007 .xlsx format. Example:

ExcelExport ee = new ExcelExport(table, new XSSFWorkbook(), "title", null, 
"file.xlsx", false);
ee.setMimeType("application/vnd.openxmlformats-officedocument.spreadsheetml.shee
t");
ee.export();

Original comment by rostisla...@gmail.com on 26 Aug 2013 at 5:01