Generate CSV file

Question

Can someone point me to some good tutorials for generating a resultset into a CSV or even Excel file?

I'm using j2ee, with Spring and Hibernate.

If you're using Hibernate, why are you dealing with raw ResultSets at all? — Matt Ball, Jun 04 '11 at 01:26
the best advice for java users would be "the new line is \n\r , not \n" — kommradHomer, Mar 23 '12 at 09:14

score 2 · Answer 1 · answered Jun 04 '11 at 01:26

2

Here is a utility that does CSV reading and writing:

http://opencsv.sourceforge.net/

answered Jun 04 '11 at 01:26

astay13

6,557
9
37
55

score 1 · Answer 2 · edited May 23 '17 at 10:00

1

can someone point me to some good tutorials for generating a resultset into a csv

It's extremely straightforward to roll your own — just make sure to use StringBuilder or Joiner. Or, use a library.

or even excel file.

You'll want to use Apache POI for that.

edited May 23 '17 at 10:00

Community

1
1

answered Jun 04 '11 at 01:28

Matt Ball

344,413
96
627
693

score 0 · Answer 3 · answered Jun 06 '11 at 03:51

Use opencsv 2.2.jar

http://opencsv.sourceforge.net/

CSVWriter writer = new CSVWriter(new FileWriter("yourfile.csv"), '\t'); // feed in your array (or convert your data to an array) String[] entries = "first#second#third".split("#"); writer.writeNext(entries); writer.close();

Generate CSV file

3 Answers3