poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "KHZ (SAW)" <karl-heinz.zenge...@sawag.com>
Subject AW: How to extract text from Excel file?
Date Mon, 14 Feb 2005 16:17:35 GMT
Hi Petr.

Look at

http://jakarta.apache.org/poi/hssf/how-to.html

Read it exactly and there's a further link which contains that sample
HSSF class.

It's an example about reading and writing.

You just use the reading part and construct strings from the retrieved
values. If you've formulas it's either knowing the proper type or
guessing the best choice (a non empty value). If you apply (formula
cell) the get operation for a certain type and the real content is from
a different type you don't receive an exception. There you receive an
empty value of that certain type.

Regards,	Karl-Heinz.


-----Urspr├╝ngliche Nachricht-----
Von: Andrš Petr (EXT) [mailto:PAndrs@csas.cz] 
Gesendet: Montag, 14. Februar 2005 17:04
An: poi-user@jakarta.apache.org
Betreff: How to extract text from Excel file?

Hi,

I need to extract plain text from Excel file to supply it to indexing
engine (I need to create text extractor for Jive to enable indexing of
Excel files). What is the best way to do this with POI? Should I use
HSSF or directly POIFS? Or some other tool is better to do this?

Thanks

Petr

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