Java API that can convert Excel Sheet into Database Table [closed]

Question

Closed. This question is seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. It does not meet Stack Overflow guidelines. It is not currently accepting answers.

We don’t allow questions seeking recommendations for software libraries, tutorials, tools, books, or other off-site resources. You can edit the question so it can be answered with facts and citations.

Closed 9 years ago.

Improve this question

Is there any APIs available in Java that can convert an Excel Sheet into a database table? And also for drawing charts and graphs?

It will be a two step process. Step 1 is to convert the Excel Sheet into data you can use and Step 2 will be loading that data into the database. As a general rule of thumb, you should define your database tables ahead of time instead of dynamically generating them. — FloppyDisk
– FloppyDisk, Commented Oct 6, 2011 at 14:39

koppor · Accepted Answer · 2011-10-06 13:58:10Z

4

A first step could be the POI project of Apache. For graphdrawing, I used to use the Pefuse Framework.

answered Oct 6, 2011 at 13:58

koppor

20.9k16 gold badges131 silver badges178 bronze badges

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

Comments

Eugene Kuleshov · Accepted Answer · 2011-10-06 13:58:01Z

2

You can use Apache POI project to read Excel documents.

answered Oct 6, 2011 at 13:58

Eugene Kuleshov

31.8k5 gold badges70 silver badges67 bronze badges

Comments

l_39217_l · Accepted Answer · 2011-10-06 14:01:37Z

2

XLSQL

http://sourceforge.net/projects/xlsql/

answered Oct 6, 2011 at 14:01

l_39217_l

2,1101 gold badge13 silver badges15 bronze badges

Comments

Daniel Pereira · Accepted Answer · 2011-10-06 13:53:09Z

0

Well there is this, but just Google it because there are many options for manipulating excel sheets with java.

answered Oct 6, 2011 at 13:53

Daniel Pereira

1,78312 silver badges10 bronze badges

Collectives™ on Stack Overflow

Java API that can convert Excel Sheet into Database Table [closed]

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

Comments

Comments

Linked

Related