Exporting SQL query result to csv or Excel

by

With use of openCSV API, you can export your data in csv file.

CSVWriter writer = new CSVWriter(new FileWriter("yourfile.csv"), '\t');
Boolean includeHeaders = true;

java.sql.ResultSet myResultSet = .... //your resultset logic here

writer.writeAll(myResultSet, includeHeaders);

writer.close();

More Related Contents:

  1. Converting JSON to XLS/CSV in Java [closed]
  2. CSV file with “ID” as first item is corrupt in Excel
  3. How to escape comma and double quote at same time for CSV file?
  4. How should I escape commas and speech marks in CSV files so they work in Excel?
  5. Keep the order of the JSON keys during JSON conversion to CSV
  6. How do I get the size of a java.sql.ResultSet?
  7. What is the best approach using JDBC for parameterizing an IN clause? [duplicate]
  8. How to print a query string with parameter values when using Hibernate
  9. MySQL and JDBC with rewriteBatchedStatements=true
  10. directly convert CSV file to JSON file using the Jackson library
  11. Convert an XML file to CSV file using java
  12. How to read Excel cell having Date with Apache POI?
  13. Parse CSV with double quote in some cases
  14. Hibernate Group by Criteria Object
  15. Read CSV file column by column
  16. dll missing in JDBC
  17. What is the better API to Reading Excel sheets in java – JXL or Apache POI [closed]
  18. Password Protected Excel File
  19. How to add JCheckBox in JTable?
  20. Inserting null to an Integer column using JDBC
  21. How to implement a SQL like ‘LIKE’ operator in java?
  22. Apache-POI sorting rows in excel
  23. How to fill up a TableView with database data
  24. How to do in-query in jDBI?
  25. A datetime equivalent in java.sql ? (is there a java.sql.datetime ?)
  26. Java JDBC connection status
  27. Is MERGE an atomic statement in SQL2008?
  28. Make column read-only using apache poi
  29. Hibernate Issue : Foreign key must have same number of columns as referenced primary key
  30. Does JPA support mapping to sql views?

Leave a Comment