poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Agarwal, Garima " <Garima.Agar...@delphi.com>
Subject RE: Urgent help needed: How to read Excel having List type cell
Date Fri, 11 Aug 2006 10:58:00 GMT

Yeah Karl,
Hope my code doesn't crash midway :)

-----Original Message-----
From: KHZ (SAW) [mailto:karl-heinz.zengerle@sawag.com]
Sent: Friday, August 11, 2006 3:36 PM
To: 'POI Users List'
Subject: AW: Urgent help needed: How to read Excel having List type cell

Hi Garima.

So it seems to still have been the version problem which POI didn't have in
2.0, but in 2.5. So let's hope that 3.0 will be quite stable.

Regards,	Karl-Heinz.


-----Urspr√ľngliche Nachricht-----
Von: Agarwal, Garima [mailto:Garima.Agarwal@delphi.com]
Gesendet: Freitag, 11. August 2006 09:39
An: poi-user@jakarta.apache.org
Betreff: RE: Urgent help needed: How to read Excel having List type cell





I solved the problem by using POI 3.0 alpha2 jar, if someone is
interested in knowing.

Have a good day,

Garima.

________________________________

From: Agarwal, Garima

Sent: Thursday, August 10, 2006 3:27 PM
To: poi-user@jakarta.apache.org
Subject: Urgent help needed: How to read Excel having List type cell




Got a project code release, could someone give pointers as to what all I
can try to correct the error?

My code is reading an excel file contains one of the cell as Data ->
validation -> settings -> List type, able to read first time but if I
change the list cell value using the drop down and save and try reading
again I get the following 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)







Here is the code sample:

(Second time tool is not able to get past the underlined,colored line
even)




FileInputStream inputStream = new FileInputStream(mpiFileLocation);

poiFileSystem = new POIFSFileSystem(inputStream);

workBook = new HSSFWorkbook(poiFileSystem,false);




Please help,

Thanks in advance,

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.


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



---------------------------------------------------------------------
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/


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

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.

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

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