The product that I work on is called ConverterPro,
data migration tool that moves data across different
dbms. I am sure you can find more on this on the
internet.
So, to that end, I am moving this table from SQL
Server containing 1mil. rows to excel. As I also
suggested in my email, I was considering moving these
rows across to say 4 workbooks each containing 4
sheets.
--- Ryan Ackley <[EMAIL PROTECTED]> wrote:
> Just out of curiousity, what are you doing that
> requires you to output 1
> million rows? It seems like it would be hard to find
> stuff in a workbook
> that has a million rows. I would think that it would
> be better to break them
> into smaller files named appropriately for a
> subcategory or something.
>
> -Ryan
>
> ----- Original Message -----
> From: "Davinder Kohli" <[EMAIL PROTECTED]>
> To: "POI Users List" <[EMAIL PROTECTED]>
> Sent: Monday, June 28, 2004 10:21 AM
> Subject: Re: Creating Excel File
>
>
> > An excel sheet can hold upto 65536 rows. This is
> limit
> > by MS Excel and not POI. If you need to move/write
> > rows > 65536, you may have to write them across
> > multiple sheets.
> >
> > To get rid of the out of memory problem, icrease
> your
> > JVM memory size to say 512M using -Xmx.
> >
> > In fact, I am running into the same problem,
> however,
> > in my case I am trying to move 1 million row table
> to
> > excel and there is so much I can do by increasing
> the
> > memory size.
> >
> > My question to HSSF gurus:
> > Can I append to an existing worksheet in a
> workbook
> > without reading in the entire workbook into the
> user
> > model?
> >
> > I am also thinking of storing those million rows
> > across multiple workbooks instead of having 16,17
> > workseets withing a single workbook.
> >
> > Thanks,
> > Davinder
> >
> > --- Prashant Dube <[EMAIL PROTECTED]> wrote:
> > > Is there a limit to the number of lines in an
> excel
> > > file created using POI? I am getting a
> > > java.lang.OutOfMemoryError in a test that
> attempts
> > > to create an excel file having 2 sheets and 5000
> > > rows of data with 50 columns in each row. Also
> is
> > > there a way to write the file in bits (i.e.
> execute
> > > wb.write(fout) method) to avoid memory loadup.
> > >
> > > Below is the POI code that uses POI version 2.5.
> > >
> > > File xlfile = new File("C:\temp\test.xls");
> > > FileOutputStream fout = new
> > > FileOutputStream(xlfile);
> > > HSSFWorkbook wb = new HSSFWorkbook();
> > > HSSFSheet sheet1 = wb.createSheet("sheet1");
> > > for (int j=0;j<=5000;j++) {
> > > row = sheet1.createRow(j);
> > > for (int i=0;i<=50;i++) {
> > > cell = row.createCell((short)i);
> > > cell.setCellType(HSSFCell.CELL_TYPE_STRING);
> > > cell.setCellValue("Hello");
> > > }
> > > }
> > > HSSFSheet sheet2 = wb.createSheet("sheet2");
> > > for (int j=0;j<=5000;j++) {
> > > row = sheet2.createRow(j);
> > > for (int i=0;i<=50;i++) {
> > > cell = row.createCell((short)i);
> > > cell.setCellType(HSSFCell.CELL_TYPE_STRING);
> > > cell.setCellValue("World");
> > > }
> > > }
> > > wb.write(fout);
> > > fout.close();
> > >
> > > Thanks
> > > PD
> > >
> >
> >
> >
> >
> > __________________________________
> > Do you Yahoo!?
> > Read only the mail you want - Yahoo! Mail
> SpamGuard.
> > http://promotions.yahoo.com/new_mail
> >
> >
>
---------------------------------------------------------------------
> > To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> > For additional commands, e-mail:
> [EMAIL PROTECTED]
> >
>
>
>
---------------------------------------------------------------------
> To unsubscribe, e-mail:
> [EMAIL PROTECTED]
> For additional commands, e-mail:
> [EMAIL PROTECTED]
>
>
__________________________________
Do you Yahoo!?
Read only the mail you want - Yahoo! Mail SpamGuard.
http://promotions.yahoo.com/new_mail
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
