Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "POI Users List" <poi-user@jakarta.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Reply-To: <karl-heinz.zengerle@sawag.com>
From: "KHZ (SAW)" <karl-heinz.zengerle@sawag.com>
To: "'POI Users List'" <poi-user@jakarta.apache.org>
Subject: AW: Urgent help needed: How to read Excel having List type cell
Date: Thu, 10 Aug 2006 12:01:21 +0200
Organization: SAW
Message-ID: <004f01c6bc63$ee6330e0$a500000a@karlheinzmobil>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thread-Index: Aca8Y0N4PNPg/3q1R7uwWnsZCodqXQAAFPZA
In-Reply-To: 
 <9F67522FAAB9EA4A8D7068C8D202643EFC2EE1@INKARBLR-EX01.Asia.DelphiAuto.net>

Hi Garima.

Which POI version do you use?

"Long" ago there were such problems using 2.5 which were not in 2.0. But =
I
think already with 2.5.1 such problems were removed.

If you're using a quite new version that something different should be =
the
reason.

Regards,	Karl-Heinz.


-----Urspr=FCngliche Nachricht-----
Von: Agarwal, Garima [mailto:Garima.Agarwal@delphi.com]=20
Gesendet: Donnerstag, 10. August 2006 11:57
An: poi-user@jakarta.apache.org
Betreff: 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 =3D new FileInputStream(mpiFileLocation);

poiFileSystem =3D new POIFSFileSystem(inputStream);

workBook =3D 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/