Hi Carlos. You'll have to read the same template several times. You've to use a counter that shows you that the limit is reached (or better that you're near the limit because you might have groups of rows belonging together). You've to memorize your state somehow.
Having reached the limit you've to save your template filled with data under name 1 and then you've to open the template again and load further data. We ourselves have run a copier from n input files 1-by-1 to n output files. So it also shouldn't be a problem to copy from a database as input to n output files. Regards, Karl-Heinz. -----Ursprüngliche Nachricht----- Von: Carlos Bergueira [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 22. September 2005 19:20 An: [email protected] Betreff: Excel generating multiple files Hi All, I need write data (records from MySql) into an excel file. Problem is: I need more than excel sheet capacity; i.e, more than 65536. That's why I want to create the following filosofy: file_1.xls, file_2.xls, etc., file_n.xls. My java class is generating only one file and data are alwayes write into the same file/sheet/row ! Do someone have a code that generate multiple excel file ? Help is appreciate ! Thanks. -- Cumprts, Carlos Bergueira --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
