AW: Extract Text From Excel

2006-07-31 Thread Leimbach, Johannes
Hello, first of all: I do have a first name. It's "Johannes", and I prefer being called "Johannes" over "Leimbach". Thanks ;) To your problem: Can you provide more information about it? What's in the cells and where do these errors come from? As far as I know HSSF is not able to read formulas

Re: Extract Text From Excel

2006-07-31 Thread Feris Thia
Hello Suba, Michael and Leimbach, Thanks for the responses... it greatly helps me. Especially to Leimbach, I have used your wrapper and tested it with my application. It works great :) But I have some warnings (attach below) ... . Is it a limitation of HSSF not to be able to read some Excel form

AW: Extract Text From Excel

2006-07-31 Thread Leimbach, Johannes
Hello, last week I wrote a wrapper class to facilitate text extraction from Excel files, please see the sourcecode below. Maybe this (or another example, don't care) should be posted on the POI homepage - I see very few beginner's documentation there. Anyway, here's the class, should be self

Re: Extract Text From Excel

2006-07-31 Thread Michael J. Prichard
Hey Feris, That [HSSF] is what I use as well and it works pretty good. -Michael Suba Suresh wrote: You can use the hssf libraries for excel text extraction. I used it for lucene indexing. suba suresh. Feris Thia wrote: Hi All, I'm new to this user group. Is there any way to extract al

Re: Extract Text From Excel

2006-07-31 Thread Suba Suresh
You can use the hssf libraries for excel text extraction. I used it for lucene indexing. suba suresh. Feris Thia wrote: Hi All, I'm new to this user group. Is there any way to extract all the text from Excel documents ? Want to perform indexing using POI + Lucene :) Thanks, Feris --

Extract Text From Excel

2006-07-31 Thread Feris Thia
Hi All, I'm new to this user group. Is there any way to extract all the text from Excel documents ? Want to perform indexing using POI + Lucene :) Thanks, Feris

Re: Office files properties

2006-07-31 Thread Nick Burch
On Sun, 30 Jul 2006, Zala Pierre GOUPIL wrote: I've tried to import SVN repository of POI into my Eclipse, but no way. Sounds like you need to go and read an eclipse tutorial then. That's not something we can help you with Maybe you, Nick, could send me a .jar ? I can't see where I'm wrong,

Writing properties

2006-07-31 Thread Zala Pierre GOUPIL
Hi all, I've finally managed to install an ad-hoc version of POI, thanks to ibiblio.org's jars. I want to write Office properties : somewhere, the tutorial says : --- Writing is quite simple, as the following line of code shows: dsi.setCategory("POI example"); This statement sets the "categor