Win a copy of Mesos in Action this week in the Cloud/Virtualizaton forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Best Java API for Excel

 
Rajagopal Manohar
Ranch Hand
Posts: 183
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Pie
Posts: 20532
54
Chrome Eclipse IDE Java Windows
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
All I can give you is Accessing File Formats.
 
Rajagopal Manohar
Ranch Hand
Posts: 183
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
thanks will go for JExcelAPI
 
Ulf Dittmer
Rancher
Posts: 42967
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 183
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
aha!!! okies
ps: just realizing how hard it is to code with out an IDE
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic