aspose file tools*
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 JavaScript Promises Essentials this week in the JavaScript 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: 19757
    
  20

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: 42592
    
  65
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
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Best Java API for Excel