will POI 3.5 support million data in single worksheet

[navjamsster <ku...@in.ibm.com>]

Hi, 
I wanted to know Is POI 3.5 version support to create million data in single
worksheet.?
What is the maximum limit when we are using macro in the excel file.

Regards
Naveen
-- 
View this message in context: http://www.nabble.com/will-POI-3.5-support-million-data-in-single-worksheet-tp21701154p21701154.html
Sent from the POI - User mailing list archive at Nabble.com.


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org

Re: will POI 3.5 support million data in single worksheet

[Yegor Kozlov <ye...@dinom.ru>]

The limit for .xls is 2^16 (65535 rows), for .xlsx is 2^20 (1048576 rows).

In theory POI is limited only by the size of your JVM, if it is big enough to fit the data then you will be able to 
generate "big grids". In practice, the maximum limit of heap on 32-bit JVM is 2GB (If you are using 64-bit JDK then the 
possible heap size is much bigger).  2GB is enough to fit approximately 10K or rows, the exact limit depends on the 
row-cell grid density (sparse grids require less memory).

If you generate .xlsx files, then you can stream the data directly in XML. See an example that demonstrates the idea:
http://svn.apache.org/repos/asf/poi/trunk/src/examples/src/org/apache/poi/xssf/usermodel/examples/BigGridDemo.java

Yegor

> Hi, 
> I wanted to know Is POI 3.5 version support to create million data in single
> worksheet.?
> What is the maximum limit when we are using macro in the excel file.
> 
> Regards
> Naveen


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org