I had never updated these methods from when I was using 1.5.x. I changed my sheet.createRow statements to use an int and tested against 65500 and everything works great! Thanks for all your help.
Brian Glick Freightek, Inc. (215) 887-6100 [EMAIL PROTECTED] -----Original Message----- From: Andrew C. Oliver [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 09, 2003 12:08 PM To: POI Users List Subject: Re: Wrapping rows to a new sheet yes... this is actually a bug. "short" is really a "ushort" so we should use "int" and do bounds checking... IMHO. Brian Glick wrote: >I figured it out... > >That's the code I tried first, but since the row number is defined as a >short, line 32768 is really -32768 and line 32769 is really -32767. Line >65535 = 0. > >What I ended up doing is changing the if statement to: > >if(rowNumber < 0 && rowNumber > -2) > >This will return true at line 65534 (which is close enough to the end for my >purposes.) > >Thanks for your help. > >Brian Glick >Freightek, Inc. >(215) 887-6100 >[EMAIL PROTECTED] > >-----Original Message----- >From: Avik Sengupta [mailto:[EMAIL PROTECTED]] >Sent: Thursday, January 09, 2003 11:43 AM >To: POI Users List >Subject: Re: Wrapping rows to a new sheet > >Something on the lines of :-- >======================================= >short rowNumber = 0; >mySheet = workbook.createSheet(); >HSSFRow r; > >while(rs.next()) >{ > r = mySheet.createRow(rowNumber); > //write cells in row > rowNumber++; > if (rowNumber > 65000) { > mySheet=workbook.createSheet(); > rowNumber=0; > } >} > >============================================== >On Thu, 2003-01-09 at 21:41, Brian Glick wrote: > > >>Does anyone have a method to create a new sheet once you've exceeded the >> >> >65K > > >>row limit in a sheet? I'm trying to run a 70,000 line report, and I want >> >> >to > > >>wrap the records into a new sheet. >> >>Basically what I'm doing now is: >> >>short rowNumber = 0; >>HSSFRow r = mySheet.createRow(rowNumber); >> >>while(rs.next()) >>{ >> //write cells in row >> rowNumber++; >>} >> >>I figure I need to replace "rowNumber++" with a method to return the next >>number or set "mySheet" to a new sheet and return 0 to start over, but I >>can't figure out exactly how to do this. >> >>Thanks in advance for any help, >> >>Brian Glick >>Freightek, Inc. >>(215) 887-6100 >>[EMAIL PROTECTED] >> >>-- >>To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >>For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> >> >> >> > > > > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > >-- >To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> >For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > > > > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
