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.
****************************************************************************************