How to get the values from DB and store it in a existing excel file using java?

Question

I want to store the values from the database to an existing excel file. For example if the file is stored in C: data.xls. I want the data from db table to be stored in that. I will mention the column name in the excel file itself.

Please help me to do this.

Would you consider a CSV file, or is your heart set on an Excel file? — user978122
– user978122, Commented Nov 17, 2011 at 4:55
"Please help me in doing this." Which part are you having trouble with? What have you tried? It almost seems like you are asking if someone will "gimme' da' codez?". — Andrew Thompson
– Andrew Thompson, Commented Nov 17, 2011 at 5:01
i could able to get the values from database and create a xl file and store it in that . am trying to store it in an existing excel file . — Jey Ravi
– Jey Ravi, Commented Nov 17, 2011 at 5:26

KV Prajapati · Accepted Answer · 2011-11-17 05:05:17Z

2

Use JDBC API to read/fetch result from the MySql database and jExcelAPI or Apache POI (recommended) to write/update excel document.

edited Nov 17, 2011 at 5:05

answered Nov 17, 2011 at 4:58

KV Prajapati

94.8k20 gold badges151 silver badges188 bronze badges

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

1 Comment

James Anderson Over a year ago

I would second the recommendation for Apache POI its an excellent piece of code, in many ways superior to Microsofts own .COM API.

Mansoor Siddiqui · Accepted Answer · 2011-11-17 05:09:47Z

2

Writing to a CSV file is probably the easiest way to do this. CSV files can be opened up in Excel, but cannot have any text formatting. See the CSV Wikipedia article for more details on the format.

If you would rather use an XLS or XLSX format, consider using Apache POI, as the formats of those file types (particularly XLS) is quite complicated to write to manually.

edited Nov 17, 2011 at 5:09

answered Nov 17, 2011 at 5:01

Mansoor Siddiqui

22k11 gold badges51 silver badges69 bronze badges

Comments

user978122 · Accepted Answer · 2011-11-17 04:59:58Z

1

If you are going for a CSV file, you need only open the file, and begin putting rows, one per line, with commas in between values. It's very simple, and works with a variety of software.

answered Nov 17, 2011 at 4:59

user978122

5,7917 gold badges36 silver badges42 bronze badges

3 Comments

Andrew Thompson Over a year ago

"commas in between values" What if the values contain commas? ;)

user978122 Over a year ago

Ok, it's slightly more complicated than that, but still ridiculously simple. It's the kind of code you write once in a given language, and never have to modify again. ^_^

Andrew Thompson Over a year ago

OK I'll concede that. :) +1 for the concept of CSV and the last sentence in your comment.

Collectives™ on Stack Overflow

How to get the values from DB and store it in a existing excel file using java?

3 Answers 3

1 Comment

Comments

3 Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

3 Comments

Related