Maximum size of Grid to display with Excel Sheet

Flow
1

Guys,

Whats the maximum size of sheet that can be displayed with the vaadin excel component ?

Is 100K rows realistic (for a 20 column work sheet) ?

Regards

2

Also is it possible to add a download for the sheet so that client can download the excel ?

3

If you have just data, row count can be pretty high. But if you have complex formulas producing lot of calculation, 100K is quite much. In some scenarios you will get real Excel jammed with that amount of rows, and browser version naturally is slower.

Regarding data export, see example here. Spreadsheet is built on POI, so you can use these directly.

https://www.mkyong.com/java/apache-poi-reading-and-writing-excel-file-in-java/

4

Hey Thanks. I have only data no formulas. So I am guessing it will be possible to show 100K rows or more.

I can use POI I was wondering if if the vaadin component can be used to provide a download button.

5

Remember that you are at least limited by the number of rows supported by the workbook type: https://stackoverflow.com/questions/11954418/apache-poi-maximum-number-of-rows

Spreadsheet the Vaadin component itself doesn’t have a “download” button, but doing it yourself shouldn’t be a problem: https://vaadin.com/docs/v8/framework/articles/LettingTheUserDownloadAFile.html
(note that you might not want to store 100k rows in memory)

-Olli

6

Yea the 100K rows will be an issue. I have a excel file created by POI which i need to stream to.
So of course anything over POI limit wont be visible.

Is there a way to stream data from the server side to the vaadin spread sheet ?
I mean so if I have 100K rows is it possible to stream the data as user scrolls ?

Regards

7

Hi Guys,

Is it possible to stream data for excel from the server side ?

Regards