poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Agarwal, Garima " <Garima.Agar...@delphi.com>
Subject How to read Excel having List type cell
Date Tue, 08 Aug 2006 11:31:57 GMT

Hi,

I am reading excel using POI, but I have started getting an error :

java.lang.reflect.InvocationTargetException

            at
sun.reflect.GeneratedConstructorAccessor134.newInstance(Unknown Source)

            at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingCons
tructorAccessorImpl.java:27)

            at
java.lang.reflect.Constructor.newInstance(Constructor.java:274)

            at
org.apache.poi.hssf.record.RecordFactory.createRecord(RecordFactory.java
:224)

            at
org.apache.poi.hssf.record.RecordFactory.createRecords(RecordFactory.jav
a:160)

            at
org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:163)



I found this happens if my excel have a cell that is defined as List
using Data -> Validation -> settings -> list



Its more strange that this cell is being the first time by Poi but if I
open the excel and change the list cell value and save and read again
thru my application using POI, the above error comes, if I change this
cell type as data->validation->settings->any value, then no problem in
reading the excel.



Please help,

I am using the latest POI release,



Garima.





****************************************************************************************

Note:  If the reader of this message is not the intended recipient, or an employee or agent
responsible for delivering this message to the intended recipient, you are hereby notified
that any dissemination, distribution or copying of this communication is strictly prohibited.
If you have received this communication in error, please notify us immediately by replying
to the message and deleting it from your computer. Thank you.

****************************************************************************************
Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message