File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes Java in General and the fly likes Interface with MS Excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "Interface with MS Excel" Watch "Interface with MS Excel" New topic

Interface with MS Excel

Sam Furtado
Ranch Hand

Joined: Jul 16, 2002
Posts: 45
Hi Guys !!!
Need to manipulate a "complex" excel file. Tried using freewares like POI and JExcelAPI
which are good however, they do not seem to work if the excel files are complex ie. if they contain macros, spilt cells etc. Is there any other API's that would do the same irrespective of the "format" of the excel file.
What can be done to solve this problem ???
Thanks Guys

Sun Certified Java Programmer<br />Sun Certified Web Component Developer
Garandi Garandi
Ranch Hand

Joined: Jan 07, 2003
Posts: 192
I used POI and it is working for me, the file had a few macro.
Thank you
I agree. Here's the link:
subject: Interface with MS Excel
It's not a secret anymore!