Return-Path: Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 19247 invoked by uid 98); 9 Jan 2003 16:41:36 -0000 X-Antivirus: nagoya (v4218 created Aug 14 2002) Received: (qmail 19228 invoked from network); 9 Jan 2003 16:41:34 -0000 Received: from daedalus.apache.org (HELO apache.org) (63.251.56.142) by nagoya.betaversion.org with SMTP; 9 Jan 2003 16:41:34 -0000 Received: (qmail 89769 invoked by uid 500); 9 Jan 2003 16:40:15 -0000 Received: (qmail 89758 invoked from network); 9 Jan 2003 16:40:14 -0000 Received: from smtp.mailix.net (216.148.213.132) by daedalus.apache.org with SMTP; 9 Jan 2003 16:40:14 -0000 Received: from [203.145.183.216] (helo=[10.0.2.122]) by smtp.mailix.net with asmtp (Exim 4.01) id 18Wfiz-0002Ps-00 for poi-user@jakarta.apache.org; Thu, 09 Jan 2003 08:40:10 -0800 Subject: Re: Wrapping rows to a new sheet From: Avik Sengupta To: POI Users List In-Reply-To: <719136C5198DD511B3C600010321D6DF37A98A@FTEK1> References: <719136C5198DD511B3C600010321D6DF37A98A@FTEK1> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 (1.0.8-10) Date: 09 Jan 2003 22:13:28 +0530 Message-Id: <1042130618.28839.22.camel@IT-avik> Mime-Version: 1.0 X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N 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 > b.glick@freightek.com > > -- > To unsubscribe, e-mail: > For additional commands, e-mail: >