CODEWITHSUNDEEP
javacsv
Hammelkeule
Hammelkeule

Reputation: 317

Write List into .csv file

I have a list and want to write the data into .csv file.

This is an example how my list looks like:

enter image description here

Each element contains the values from a database table. I deleted the information here. For example List[0] contains id = 1, name = Test, date = 02.02.2016 etc.

This is my code so far, but I have no Idea how to continue.

  List<String> lines = Arrays.asList("ColumnHeader", "ColumnHeader", " ColumnHeader","ColumnHeader","ColumnHeader");
  Path file = Paths.get(test.csv");
  Files.write(file, lines, Charset.forName("Windows-1252"));

Upvotes: 0

Views: 3536

Answers (1)

JimHawkins
JimHawkins

Reputation: 4994

Take a look at OpenCSV. This library contains tools for writing List and array objects to csv files, and even database result sets can be written directly to a file.

CSVWriter writer = new CSVWriter(new FileWriter("yourfile.csv"), '#');
java.sql.ResultSet myResultSet = ....
writer.writeAll(myResultSet, includeHeaders);
writer.close();

Upvotes: 1

Related Questions