Writing data to excel sheet java

Question

I am trying to read data from database and then need to write the data to an excel/csv file in an java application. The data from database can be more than 10000 rows. So could someone suggest a nice solution taking into account the performance issue also.

Is there a way we can directly read and write to excel sheet.

Thanks in advance, Kathy.

Try this tuto: http://stackoverflow.com/questions/3454975/writing-to-excel-in-java — Franklin Hirata, Jan 31 '14 at 19:30
Another solution for [writing Excel data in Java](https://www.gemboxsoftware.com/spreadsheet-java/examples/create-write-excel-file-in-java/402), I find the API a bit cleaner and easier to work with. — NixonUposseen, Nov 18 '19 at 11:01

score 1 · Answer 1 · edited Jan 31 '14 at 19:41

1

Apache POI will best suits to your problem.

Try the following references example and document.

The second reference will give you the whole implementation of how to work with POI.

edited Jan 31 '14 at 19:41

Tiny

27,221
105
339
599

answered Jan 31 '14 at 19:33

Girish

1,717
1
18
30

score 1 · Accepted Answer · answered Jan 31 '14 at 19:33

1

You can use Apache POI to do this: http://poi.apache.org

Use the HSSFWorkbook as an abstraction of a .xls workbook. There's also a XSSF format for the newer XML-based Excel files (.xlsx, etc).

answered Jan 31 '14 at 19:33

Ben Griffiths

1,676
15
13

score 0 · Answer 3 · answered Jan 31 '14 at 19:32

0

When it comes to java excel you should try out Apache POI.

answered Jan 31 '14 at 19:32

Helios

851
2
7
22

score 0 · Answer 4 · answered Jan 31 '14 at 19:32

0

Apache has a nice library that should meet your requirements.

Look into http://poi.apache.org/

Hope this helps.

answered Jan 31 '14 at 19:32

Tanmay Patil

6,882
2
25
45

Writing data to excel sheet java

4 Answers4

Linked