CODEWITHSUNDEEP
javaexcel
Krbd
Krbd

Reputation: 13

Writing data to excel sheet java

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.

Upvotes: 1

Views: 2107

Answers (4)

Girish
Girish

Reputation: 1717

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.

Upvotes: 1

Ben Griffiths
Ben Griffiths

Reputation: 1696

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).

Upvotes: 1

Tanmay Patil
Tanmay Patil

Reputation: 7057

Apache has a nice library that should meet your requirements.

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

Hope this helps.

Upvotes: 0

Helios
Helios

Reputation: 851

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

Upvotes: 0

Related Questions