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:[EMAIL PROTECTED] Gesendet: Montag, 14. Februar 2005 17:04 An: [email protected] 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: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/ --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] Mailing List: http://jakarta.apache.org/site/mail2.html#poi The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
