poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Prashanthi Maramreddy <maram...@childpsych.columbia.edu>
Subject Re: Errors in Reading a large excel file
Date Thu, 31 Jul 2003 22:30:08 GMT
>
>
>>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/


Mime
View raw message