I have not read excel files, but I have created excel reports with 3700+ rows with no problem.
-----Original Message----- From: Prashanthi Maramreddy [mailto:[EMAIL PROTECTED] Sent: Thursday, July 31, 2003 5:30 PM To: POI Users List Subject: Re: Errors in Reading a large excel file > > >>Hello: >> >> >> >> I have been using the POI application to read data from excel file. I >>recently noticed that whenever I try to read excel file with over 300 >>rows it generates the following error message. However, this does not >>happen while reading a smaller excel file. I would like to know if there >>is any limitation on the size of the HSSFWorkbook or HSSFSheet. If so >>what is it? If not could you please get back to me on the below >>generated error. >> >> >> >> >> >> >> >>java.lang.NegativeArraySizeException: >> >> >> >>at >>org.apache.poi.hssf.record.SSTDeserializer.readStringRemainder(SSTDeserial izer.java:335) >> >> >> >>at >>org.apache.poi.hssf.record.SSTDeserializer.processContinueRecord(SSTDeseri alizer.java:320) >> >> >> >>at >>org.apache.poi.hssf.record.SSTRecord.processContinueRecord(SSTRecord.java: 540) >> >> >> >>at >>org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.java: 210) >> >> >> >>at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:140) >> >> >> >>at edu.columbia.jade.system.DBDialog.readTheExcelFile(DBDialog.java:4790) >> >> >> >>at >>edu.columbia.jade.system.DBDialog.generateTheQuestionaire(DBDialog.java:31 48) >> >> >> >>at >>edu.columbia.jade.system.DBDialog.importMenuItem_ActionPerformed(DBDialog. java:4226) >> >> >> >>at edu.columbia.jade.system.DBDialog.connEtoC15(DBDialog.java:458) >> >> >> >>at edu.columbia.jade.system.DBDialog.access$29(DBDialog.java:454) >> >> >> >>at >>edu.columbia.jade.system.DBDialog$IvjEventHandler.actionPerformed(DBDialog .java:125) >> >> >> >>at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1461) >> >> >> >>at >>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractBut ton.java:1515) >> >> >> >>at >>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java :392) >> >> >> >>at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:264) >> >> >> >>at javax.swing.AbstractButton.doClick(AbstractButton.java:290) >> >> >> >>at >>javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Bas icMenuItemUI.java:957) >> >> >> >>at java.awt.Component.processMouseEvent(Component.java:3799) >> >> >> >>at java.awt.Component.processEvent(Component.java:3628) >> >> >> >>at java.awt.Container.processEvent(Container.java:1195) >> >> >> >>at java.awt.Component.dispatchEventImpl(Component.java:2678) >> >> >> >>at java.awt.Container.dispatchEventImpl(Container.java:1244) >> >> >> >>at java.awt.Component.dispatchEvent(Component.java:2581) >> >> >> >>at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2487) >> >> >> >>at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2252) >> >> >> >>at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2161) >> >> >> >>at java.awt.Container.dispatchEventImpl(Container.java:1231) >> >> >> >>at java.awt.Window.dispatchEventImpl(Window.java:964) >> >> >> >>at java.awt.Component.dispatchEvent(Component.java:2581) >> >> >> >>at java.awt.EventQueue.dispatchEvent(EventQueue.java:434) >> >> >> >>at >>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread. java:172) >> >> >> >>at >>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.ja va:131) >> >> >> >>at java.awt.Dialog.show(Dialog.java:394) >> >> >> >>at edu.columbia.jade.system.DBDialog.showDialog(DBDialog.java:5635) >> >> >> >>at edu.columbia.jade.system.SystemMain.showDBDialog(SystemMain.java:2822) >> >> >> >>at >>edu.columbia.jade.system.SystemMain.openFileMenuItem_ActionPerformed(Syste mMain.java:2277) >> >> >> >>at edu.columbia.jade.system.SystemMain.connEtoC3(SystemMain.java:449) >> >> >> >>at edu.columbia.jade.system.SystemMain.access$6(SystemMain.java:445) >> >> >> >>at >>edu.columbia.jade.system.SystemMain$IvjEventHandler.actionPerformed(System Main.java:82) >> >> >> >>at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1461) >> >> >> >>at >>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractBut ton.java:1515) >> >> >> >>at >>javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java :392) >> >> >> >>at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:264) >> >> >> >>at javax.swing.AbstractButton.doClick(AbstractButton.java:290) >> >> >> >>at >>javax.swing.plaf.basic.BasicMenuItemUI$MouseInputHandler.mouseReleased(Bas icMenuItemUI.java:957) >> >> >> >>at java.awt.Component.processMouseEvent(Component.java:3799) >> >> >> >>at java.awt.Component.processEvent(Component.java:3628) >> >> >> >>at java.awt.Container.processEvent(Container.java:1195) >> >> >> >>at java.awt.Component.dispatchEventImpl(Component.java:2678) >> >> >> >>at java.awt.Container.dispatchEventImpl(Container.java:1244) >> >> >> >>at java.awt.Component.dispatchEvent(Component.java:2581) >> >> >> >>at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:2487) >> >> >> >>at java.awt.LightweightDispatcher.processMouseEvent(Container.java:2252) >> >> >> >>at java.awt.LightweightDispatcher.dispatchEvent(Container.java:2161) >> >> >> >>at java.awt.Container.dispatchEventImpl(Container.java:1231) >> >> >> >>at java.awt.Window.dispatchEventImpl(Window.java:964) >> >> >> >>at java.awt.Component.dispatchEvent(Component.java:2581) >> >> >> >>at java.awt.EventQueue.dispatchEvent(EventQueue.java:434) >> >> >> >>at >>java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchThread. java:172) >> >> >> >>at >>java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.ja va:131) >> >> >> >>at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:126) >> >> >> >>at java.awt.EventDispatchThread.run(EventDispatchThread.java:118) >> >> >> >> >> >>Prashanthi. >> >> >> >> >> >>--------------------------------------------------------------------- >>To unsubscribe, e-mail: [EMAIL PROTECTED] >>Mailing List: http://jakarta.apache.org/site/mail2.html#poi >>The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ >> >> >> >> > > > >--------------------------------------------------------------------- >To unsubscribe, e-mail: [EMAIL PROTECTED] >Mailing List: http://jakarta.apache.org/site/mail2.html#poi >The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ > > > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
