• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Jeanne Boyarsky
  • Ron McLeod
  • Paul Clapham
  • Liutauras Vilda
Sheriffs:
  • paul wheaton
  • Rob Spoor
  • Devaka Cooray
Saloon Keepers:
  • Stephan van Hulst
  • Tim Holloway
  • Carey Brown
  • Frits Walraven
  • Tim Moores
Bartenders:
  • Mikalai Zaikin

Best Java API for Excel

 
Ranch Hand
Posts: 183
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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.
 
Sheriff
Posts: 22783
131
Eclipse IDE Spring VI Editor Chrome Java Windows
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
thanks will go for JExcelAPI
 
Rancher
Posts: 43081
77
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • 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
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
aha!!! okies
ps: just realizing how hard it is to code with out an IDE
 
To avoid criticism do nothing, say nothing, be nothing. -Elbert Hubbard. Please critique this tiny ad:
a bit of art, as a gift, the permaculture playing cards
https://gardener-gift.com
reply
    Bookmark Topic Watch Topic
  • New Topic