Can anyone tell me what are the API's used for handling unstructured
data i.e data in word or excel files
Roland - 19 May 2005 12:10 GMT
> Can anyone tell me what are the API's used for handling unstructured
> data i.e data in word or excel files
Jakarta POI
<http://jakarta.apache.org/poi/index.html>

Signature
Regards,
Roland de Ruiter
___ ___
/__/ w_/ /__/
/ \ /_/ / \
Matt Humphrey - 19 May 2005 12:17 GMT
> Can anyone tell me what are the API's used for handling unstructured
> data i.e data in word or excel files
Data in word and excel files is highly structured. There are some tools for
getting at it, but it's generally not easy to get to from Java.
http://groups-beta.google.com/group/comp.programming/browse_thread/thread/17
286030326ea233/b19148f6eefa25d2?q=%22microsoft+word%22+java&rnum=1#b19148f6e
efa25d2
also http://www.ezjcom.com/google.html
There is more on Google.
Cheers,
Matt Humphrey matth@ivizNOSPAM.com http://www.iviz.com/
Rivky - 19 May 2005 15:53 GMT
There is an open source API for handling excel files:
http://www.andykhan.com/jexcelapi/
Matt Humphrey - 19 May 2005 21:11 GMT
> There is an open source API for handling excel files:
>
> http://www.andykhan.com/jexcelapi/
Great! Thanks,
Bruce Lee - 20 May 2005 06:59 GMT
Can't JDBC get into Excel spreadsheets?
alan@engrm.com - 20 May 2005 16:45 GMT
> Can't JDBC get into Excel spreadsheets?
I think the MS Jet database engine has a driver for text files, which
would make it possible if you export to CSV.
I always get to Excel by saving as CSV, then parsing the CSV. I've got the
parse algorithm, with quote escaping and CRLF considerations, if anyone
wants it.
--
Alan Gutierrez - alan@engrm.com
- http://engrm.com/blogometer/index.html
- http://engrm.com/blogometer/rss.2.0.xml
Christopher Baldwin - 19 May 2005 16:05 GMT
SoftArtisans OfficeWriter does Word and Excel in a Java API:
http://officewriter.softartisans.com/officewriter-240.aspx
Best regards,
Chris