You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by Prashanthi Maramreddy <ma...@childpsych.columbia.edu> on 2003/08/01 00:30:08 UTC
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(SSTDeserializer.java:335)
>>
>>
>>
>>at
>>org.apache.poi.hssf.record.SSTDeserializer.processContinueRecord(SSTDeserializer.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:3148)
>>
>>
>>
>>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(AbstractButton.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(BasicMenuItemUI.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.java: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(SystemMain.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(SystemMain.java:82)
>>
>>
>>
>>at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:1461)
>>
>>
>>
>>at
>>javax.swing.AbstractButton$ForwardActionEvents.actionPerformed(AbstractButton.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(BasicMenuItemUI.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.java:131)
>>
>>
>>
>>at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:126)
>>
>>
>>
>>at java.awt.EventDispatchThread.run(EventDispatchThread.java:118)
>>
>>
>>
>>
>>
>>Prashanthi.
>>
>>
>>
>>
>>
>>---------------------------------------------------------------------
>>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>>Mailing List: http://jakarta.apache.org/site/mail2.html#poi
>>The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>>
>>
>>
>>
>
>
>
>---------------------------------------------------------------------
>To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>Mailing List: http://jakarta.apache.org/site/mail2.html#poi
>The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
>
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/