You can only create as many columns as excel will allow. I've created sheets with the maximum allowed in excel, but it escapes my memory what that is, but if I recall its > 100.
The initial capacity is a compile-time performance optimization. ITs for array lists and hash tables/etc in certain classes to prevent array reallocation one can set these larger. Its only for performance. (One day I plan to set some kind of global configuration for this instead of a compile time setting). look here: http://jakarta.apache.org/poi/javadocs/javasrc/org/apache/poi/hssf/dev/HSSF_java.html#HSSF for an example that creates a large spreadsheet. I run this regularly. To run it type "java org.apache.poi.hssf.dev.HSSF /tmp/test.xls write" with POI in your classpath. -Andy [EMAIL PROTECTED] wrote: > Hi, > > I'm working with POI 1.5.1 and when i want to create a sheet with 60 or > even 100 rows/columns it is > impossible to open the document. Excel says that it is impossible to open > such a document. > I saw that HSSFSheet have an INITIAL_CAPACITY equal at 20. Is it the source > of my problem? > > Thanks -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
