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

Best Java API for Excel

Rajagopal Manohar
Ranch Hand

Joined: Nov 26, 2004
Posts: 183
Hi Ranchers,

Context first, I am returning to java ranch, java and programming in general after 3 years :|...The thing is I need to analyse several huge excel files with under thousand rows . Doing it manually is quite daunting and I'm convinced that I should wear my programmers hat once more. A few years back JExel API and Apache POI were the packages to be used and they were not very mature at that point of time. Have things changed today, what is the best package (most easy to learn and use in my case) to use? and more importantly has java changed much....I last programmed in java 1.4 and I remember Java 1.5 has several radical changes or so I thought ...Am quite excited at the thought of programing again and general advice from ranchers will be very much appreciated

Thanks in advance,

ps: I just need to read data and do some number crunching and write it to another file.
Rob Spoor

Joined: Oct 27, 2005
Posts: 20275

All I can give you is Accessing File Formats.

How To Ask Questions How To Answer Questions
Rajagopal Manohar
Ranch Hand

Joined: Nov 26, 2004
Posts: 183
thanks will go for JExcelAPI
Ulf Dittmer

Joined: Mar 22, 2005
Posts: 42965
POI has made much bigger steps in the last few years than JExcelApi in my opinion. It also supports the new Office XML formats, while there is no sign that JExcelApi will ever do that.
Rajagopal Manohar
Ranch Hand

Joined: Nov 26, 2004
Posts: 183
aha!!! okies
ps: just realizing how hard it is to code with out an IDE
I agree. Here's the link:
subject: Best Java API for Excel
It's not a secret anymore!