Converting Excel-document into 2-dimensional array

Question

Is there any way of taking the data from an Excel-document and putting it in a 2-dimensional array using Java? I'm interested in using the data as Strings if it makes any difference.

thanks :)

How does your excel document data look like? Do you know Apache POI? If you don't, you should :) — Alfabravo
– Alfabravo, Commented Dec 26, 2011 at 22:32

Natix · Accepted Answer · 2011-12-26 22:47:32Z

3

What about Java Excel API? Very simple to use.

answered Dec 26, 2011 at 22:47

Natix

14.3k7 gold badges56 silver badges69 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ccleve · Accepted Answer · 2011-12-26 22:44:56Z

2

Use a pure-Java library. There are a few that are mature, although they're not completely bug-free. The best are Apache POI and JExcelAPI. JExcelAPI is pretty old. POI seems to have more support. I've used both.

answered Dec 26, 2011 at 22:44

ccleve

15.9k29 gold badges102 silver badges173 bronze badges

Comments

ConcernedOfTunbridgeWells · Accepted Answer · 2011-12-26 22:32:58Z

0

You can use the COM API through OLE automation and get the data out that way. This is an example of doing it with Java.

answered Dec 26, 2011 at 22:32

ConcernedOfTunbridgeWells

67.2k15 gold badges149 silver badges199 bronze badges

Collectives™ on Stack Overflow

Converting Excel-document into 2-dimensional array

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related