You are viewing a plain text version of this content. The canonical link for it is here.

Posted to user@poi.apache.org by ahnf <in...@yahoo.com> on 2007/02/13 21:47:48 UTC

Excel text extraction?

Hi,
Simular to the WordExtractor, does POI (or anyone else for that matter) provide a simple text extraction utility for just pulling all textual content out of an excel file?

thanks!

 
---------------------------------
Everyone is raving about the all-new Yahoo! Mail beta.

Re: Excel text extraction?

Posted by Daniel Noll <da...@nuix.com>.

ahnf wrote:
> Hi, Simular to the WordExtractor, does POI (or anyone else for that
> matter) provide a simple text extraction utility for just pulling all
> textual content out of an excel file?

It's reasonably easy to write one yourself.

One reason it might not be in there already is that people have wildly 
differing ideas on what constitutes "text" in an Excel document.

For example, my own opinion is that:
   - String values are text
   - Numeric and date values are not text
   - Cell comments are text

Daniel

-- 
Daniel Noll

Nuix Pty Ltd
Suite 79, 89 Jones St, Ultimo NSW 2007, Australia    Ph: +61 2 9280 0699
Web: http://nuix.com/                               Fax: +61 2 9212 6902

This message is intended only for the named recipient. If you are not
the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
message or attachment is strictly prohibited.

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