0

Possible Duplicate:
Read xlsx file in Java

I am trying to read excel sheet 2007 by java

I want to know what i need of libraries and JAR files to open and read the sheets

Thanks for help

Community
  • 1
  • 1
AZIZ
  • 11
  • 1
  • 3

2 Answers2

2

Apache POI - the Java API for Microsoft Documents. Supports xlsx format.

Andreas Dolk
  • 113,398
  • 19
  • 180
  • 268
  • it is give me that error "" Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException "" – AZIZ Aug 08 '11 at 11:02
  • The binary distributions at this location should be complete: http://poi.apache.org/download.html#POI-3.7 – Andreas Dolk Aug 08 '11 at 12:27
1

Try Apache POI.

Thomas
  • 87,414
  • 12
  • 119
  • 157
  • It is contain Jar fail xmlbean ? i was try use it but it is give me error " Exception in thread "main" java.lang.NoClassDefFoundError: org/apache/xmlbeans/XmlException " – AZIZ Aug 08 '11 at 10:59
  • @AZIZ POI consists of several components. Have a look here: http://poi.apache.org/overview.html (go to the Component Map section) - the table states `xmlbeans` is a prerequisite, so you'd have to add it as well – Thomas Aug 08 '11 at 11:12