Karl, It's +/- what i am doing; problem is in opening and closing workbook (i think !). Hi Tommy, Could you pls send me you class to look for help ! I think the way is +/- the same; maybe i can change my filosofy of generating a lot of files to have more than one sheet into the same Thanks !
2005/9/22, KHZ (SAW) <[EMAIL PROTECTED]>: > > 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 > > > -- Cumprts, Carlos Bergueira
