CODEWITHSUNDEEP
javahibernatespring
glenn
glenn

Reputation: 143

Generate CSV file

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.

Upvotes: 0

Views: 2879

Answers (3)

Niroshan Abayakoon
Niroshan Abayakoon

Reputation: 921

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();

Upvotes: 0

Matt Ball
Matt Ball

Reputation: 359776

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.

Upvotes: 1

astay13
astay13

Reputation: 6927

Here is a utility that does CSV reading and writing:

http://opencsv.sourceforge.net/

Upvotes: 2

Related Questions