Return-Path: Delivered-To: apmail-poi-user-archive@www.apache.org Received: (qmail 87695 invoked from network); 17 Mar 2011 15:39:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.3) by minotaur.apache.org with SMTP; 17 Mar 2011 15:39:11 -0000 Received: (qmail 83809 invoked by uid 500); 17 Mar 2011 15:39:11 -0000 Delivered-To: apmail-poi-user-archive@poi.apache.org Received: (qmail 83790 invoked by uid 500); 17 Mar 2011 15:39:10 -0000 Mailing-List: contact user-help@poi.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: "POI Users List" Delivered-To: mailing list user@poi.apache.org Delivered-To: moderator for user@poi.apache.org Received: (qmail 83402 invoked by uid 99); 17 Mar 2011 15:37:58 -0000 X-ASF-Spam-Status: No, hits=2.0 required=5.0 tests=FREEMAIL_FROM,SPF_NEUTRAL,T_TO_NO_BRKTS_FREEMAIL,URI_HEX X-Spam-Check-By: apache.org Received-SPF: neutral (nike.apache.org: 216.139.236.26 is neither permitted nor denied by domain of bbarani@gmail.com) Date: Thu, 17 Mar 2011 08:37:31 -0700 (PDT) From: "bbarani@gmail.com" To: user@poi.apache.org Message-ID: <1300376251443-3884709.post@n5.nabble.com> Subject: Invalid row number (-32768) outside allowable range (0..1048575) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org Hi, This is my first question in this forum, as I am pretty new to this forum. I have been using Apache POI package for more than 3 years now but I havent used it for generating a huge excel reports. We were just generating the reports in hundreds before. Currently I am trying to generate a huge report (more than 100000 rows), but I am getting the below error. I have also printed out the rownumber for reference. The rownumber is positive but even then I am getting the error stating that its negative. Has anyone faced this issue before? 32764 32765 32766 32767 32768 **General Exception** java.lang.IllegalArgumentException: Invalid row number (-32768) outside allowable range (0..1048575) at org.apache.poi.xssf.usermodel.XSSFRow.setRowNum(XSSFRow.java:333) at org.apache.poi.xssf.usermodel.XSSFSheet.createRow(XSSFSheet.java:493) at WriteExcel.main(WriteExcel.java:128) Thanks, Barani -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Invalid-row-number-32768-outside-allowable-range-0-1048575-tp3884709p3884709.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscribe@poi.apache.org For additional commands, e-mail: user-help@poi.apache.org