5

Is there a Java Open source Library for parsing Excel 2007 Files?

hlovdal
  • 26,565
  • 10
  • 94
  • 165
Deva Annamalai
  • 59
  • 1
  • 3

8 Answers8

9

Apache POI looks promising.

Yuval F
  • 20,565
  • 5
  • 44
  • 69
5

Apache POI is the pure java answer to the question. 2007 format support is in beta right now.

OpenXLS may support it already (if GPL is fine for you). The commercial version of the same product (ExtenXLS) does support it.

Although not strictly part of the question, I should point out that any rewrite of access to Excel files will always have some deficiency over the original, so Joel Spolsky's advice is a good alternative, if you need it.

Yishai
  • 90,445
  • 31
  • 189
  • 263
3

Apache POI

kishore
  • 407
  • 3
  • 10
2

From http://poi.apache.org/apidocs/index.html

DDF - Dreadful Drawing Format This package contains classes for decoding the Microsoft Office Drawing format otherwise known as escher henceforth known in POI as the Dreadful Drawing Format.

HPSF - Horrible Property Set Format

HSSF - Horrible Spreadsheet Format

I love those guys. We will try to use POI to read Excel files, I will look at the JExcel solution too.

Ravi Wallau
  • 10,416
  • 2
  • 25
  • 34
1

http://openxml4j.org/

user101884
  • 717
  • 3
  • 7
1

Not POI. Andy Khan's JExcel is what you want.

duffymo
  • 305,152
  • 44
  • 369
  • 561
1

I did an assessment of poi and jexcel some time ago and jexcel was far superior. They both use a lot of memory though in the case that you have very large datafiles. By this I mean, I was not able to figure out how to construct an excel file through a stream, such that I didn't have to load the entire file in memory.

Nathan Feger
  • 19,122
  • 11
  • 62
  • 71
  • This is a big deal for files that are created or edited by big days-generating programs. I sometimes push Excel to its limits. Streaming may be the solution. – IceArdor Feb 25 '14 at 08:15
0

I am currently comparing JExcelApi and Apache POI. POI supports Office 2007 in Beta and looks like the best option (in many ways)