Write CSV to String using opencsv without creating an actual file or a temp file

Question

I'm trying to use the opencsv library to write a csv file. The restriction being that I do not want to create a file on the disk or even a temp file. Is there a way I can achieve it?

From what I looked, the constructor for CSVWriter requires a FileWriter object.

Thanks!

assylias · Accepted Answer · 2014-01-15 16:27:16Z

16

Actually the constructor needs a Writer and you could provide a StringWriter to create a String.

answered Jan 15, 2014 at 16:27

assylias

330k84 gold badges680 silver badges806 bronze badges

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

Comments

Leonid Dashko · Accepted Answer · 2021-01-06 10:20:36Z

11

To modify the example given here, just use a StringWriter instead of a FileWriter:

public static void main(String[] args) throws IOException {
    String[] rowData = {"column1", "column2", "column3"};

    try (StringWriter sw = new StringWriter(); CSVWriter csvWriter = new CSVWriter(sw)) {
        csvWriter.writeNext(rowData);

        String csv = sw.toString();
        System.out.println("CSV result: \n" + csv);
    }
}

edited Jan 6, 2021 at 10:20

Leonid Dashko

4,2341 gold badge23 silver badges27 bronze badges

answered Jan 15, 2014 at 16:33

mayhewsw

7249 silver badges20 bronze badges

Comments

Aaron Digulla · Accepted Answer · 2014-01-15 16:27:28Z

3

Actually, CSVWriter takes a Writer instance, so you can simply pass a StringWriter. After the write operation, you can ask the StringWriter for it's content using toString().

answered Jan 15, 2014 at 16:27

Aaron Digulla

330k111 gold badges626 silver badges840 bronze badges

Collectives™ on Stack Overflow

Write CSV to String using opencsv without creating an actual file or a temp file

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related