import data from database to Excel using java?

Question

import data from excel to database using java, i find "Apachi POI" .

But now, i want to import data from database to excel using java. May i use for this "Apachi POI" too? if no, what i must do? thanks

Have you read the documentation?

Frank Pavageau
– Frank Pavageau

2012-10-05 12:51:59 +00:00
Commented Oct 5, 2012 at 12:51 — Frank Pavageau
– Frank Pavageau, Commented Oct 5, 2012 at 12:51

Kent · Accepted Answer · 2012-10-05 12:50:50Z

1

yes. poi can write excel file.

or you can read the data from DB, then generate a CSV file (without poi). In most case, MS-Excel can open CSV format.

but if you need your Excel file to have a sexy looking.. e.g. colorful font, bgcolor. etc.. try poi.

answered Oct 5, 2012 at 12:50

Kent

197k36 gold badges248 silver badges317 bronze badges

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

Comments

Ruthreshwar · Accepted Answer · 2012-11-07 05:09:01Z

1

Yes you can use Apache POI to import data into excel from database. But the easiest way is to download as CSV file. The difference is with CSV file you cannot format the cells but with excel you can format cells as you wish. E.G)Like cell border, cell highlight, fonts these things can be done only if excel download is used. If you no need formatting then you can choose the simplest way CSV download.

answered Nov 7, 2012 at 5:09

Ruthreshwar

1,8611 gold badge19 silver badges27 bronze badges

Comments

Cyril Maitre · Accepted Answer · 2012-10-05 12:50:54Z

0

I don't know if you can use Apachi POI to import data from database to excel but you can format your database's data as csv file and import this csv into excel (excel can import it natively)

answered Oct 5, 2012 at 12:50

Cyril Maitre

4113 silver badges6 bronze badges

Collectives™ on Stack Overflow

import data from database to Excel using java?

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