OpenCSV Avoid using FileWriter and return InputStream

Question

I am using OpenCsv and the new CSVWriter() method takes a Writer as an argument.

What I am trying to achieve is that to avoid writing to the file system and instead return an InputStream. I am not sure how to go about this. Not very familiar with Streams also I am using JAVA 7.

Is it possible that I could make the writeValues method return an InputStream and avoid writing the output on file system.

This is my working implementation:

private static void writeValues(String[][] cellValues) throws IOException {

    CSVWriter writer = new CSVWriter(new FileWriter("/tmp/myfile.csv"));
    for(String[] row : cellValues) { 
        writer.writeNext(row);
    }
    writer.close();
}

This is what I want to achieve. How to Convert the above method to avoid using a FileWriter.

private static InputStream writeValues(String[][] cellValues) throws IOException {

    InputStream inputStream = ?;

    CSVWriter writer = new CSVWriter(?);
    for(String[] row : cellValues) { 
        writer.writeNext(row);
    }
    writer.close();

    return inputStream;
}

What exactly is the point of returning a consumed ByteArrayInputStream()? And what was the result of this attempt? — user207421
– user207421, Commented Mar 10, 2016 at 4:14
I was able to figure out the problem. The CSVWriter needs to be closed before writing to file. I was not using the result of the return value as I was writing a file on disk. — Aniks
– Aniks, Commented Mar 10, 2016 at 4:18

Michael Kemmerzell · Accepted Answer · 2022-11-29 11:41:10Z

19

An example implementation to convert Beans to a byte array:

public static byte[] getBeansAsByteArray(final List<YourBean> beans) {
    ByteArrayOutputStream stream = new ByteArrayOutputStream();
    OutputStreamWriter streamWriter = new OutputStreamWriter(stream);
    CSVWriter writer = new CSVWriter(streamWriter);

    StatefulBeanToCsv<YourBean> beanToCsv = new StatefulBeanToCsvBuilder(writer).build();
    beanToCsv.write(beans);
    streamWriter.flush();
    
    return stream.toByteArray();
}

edited Nov 29, 2022 at 11:41

answered Mar 24, 2020 at 12:36

Michael Kemmerzell

5,3465 gold badges35 silver badges48 bronze badges

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

Comments

JB Nizet · Accepted Answer · 2016-03-09 07:11:30Z

9

Write to an OutpuStreamWriter itself writing to a ByteArrayOutputStream, and in the end, you'll have a byte array in memory (by calling getBytes() on the ByteArrayOutputStream).

You can then read from this byte array by opening a ByteArrayInputStream on the byte array.

answered Mar 9, 2016 at 7:11

JB Nizet

694k94 gold badges1.3k silver badges1.3k bronze badges

1 Comment

Yogesh D Over a year ago

Can you share your code here as to how you used OutputStreamWriter? I am in the same boat trying to avoid writing to a file and directly return InputStream.

szuchow · Accepted Answer · 2022-02-07 06:47:18Z

5

Grab a working snippet without StatefulBeanToCsv which I do not prefer.

 String[] headers = { "id", "result", "searchTerm"};
 ByteArrayOutputStream stream = new ByteArrayOutputStream();
 OutputStreamWriter streamWriter = new OutputStreamWriter(stream);
 CSVWriter writer = new CSVWriter(streamWriter);
 writer.writeNext(headers);
 // listOfRows -> business logic collection containing data for csv rows, as you can see I've separated the declaration of headers 
 listOfRows.forEach(it -> {
        writer.writeNext(new String[] {it.getId().toString(), it.getResult(), it.getSearchTerm()});
 });

 streamWriter.flush();
 byte[] byteArrayOutputStream = stream.toByteArray();

answered Feb 7, 2022 at 6:47

szuchow

511 silver badge3 bronze badges

Comments

Majutharan Majutharan · Accepted Answer · 2021-01-06 08:59:08Z

2

This is correct implementation

public static byte[] getBeansAsByteArray(List<YourBean> beans) {
    ByteArrayOutputStream stream = new ByteArrayOutputStream();
    OutputStreamWriter streamWriter = new OutputStreamWriter(stream);
    CSVWriter writer = new CSVWriter(streamWriter);

    StatefulBeanToCsv<YourBean> beanToCsv = new StatefulBeanToCsvBuilder(writer).build();
    beanToCsv.write(beans);
    streamWriter.flush();

    return stream.toByteArray();
}

answered Jan 6, 2021 at 8:59

Majutharan Majutharan

2811 silver badge13 bronze badges

1 Comment

Majutharan Majutharan Over a year ago

@MichaelKemmerzell, see this line CSVWriter writer = new CSVWriter(streamWriter);

Collectives™ on Stack Overflow

OpenCSV Avoid using FileWriter and return InputStream

4 Answers 4

Comments

1 Comment

Comments

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related