This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "Best Java API for Excel" Watch "Best Java API for Excel" New topic
Author

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,
Rajagopal

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

Joined: Oct 27, 2005
Posts: 19649
    
  18

All I can give you is Accessing File Formats.


SCJP 1.4 - SCJP 6 - SCWCD 5 - OCEEJBD 6
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
Marshal

Joined: Mar 22, 2005
Posts: 41042
    
  43
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.


Ping & DNS - my free Android networking tools app
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
 
Consider Paul's rocket mass heater.
 
subject: Best Java API for Excel
 
Similar Threads
Unusual developer seeks unusual position; NYC/NJ or telecommute preferred
where to keep data
What is HFSJ?
Part 1 is behind me
Fastest chess?