Write into excel file using StreamingOutput object. (java.lang.ClassCastException)

Question

I have a method which returns StreamingOutput Object. And i want to write this StreamingOutput object into excel file. And i have written the following code, which is giving me the java.lang.ClassCastException Exception.

StreamingOutput stream = getStreamObject();
    SXSSFWorkbook workBook = (SXSSFWorkbook) stream; //Exception occurs here 

    FileOutputStream fileOut = new FileOutputStream("/save/excel/file/here");
    workBook.write(fileOut);
    fileOut.flush();
    fileOut.close();

So, Please help me out with this. Thank You in Advance.

right now you want to create a new object of type SXSSFWorkbook from the StreamingOutput. no wonder you get exception there. you should create a new row/cell and call stream.write() on the cell.setValue() — XtremeBaumer
– XtremeBaumer, Commented Dec 12, 2016 at 8:27
Just to be sure, did you rewrite that class? SxSSFWorkbook from apache doesn't seem to implement streamingoutput. — Tosh
– Tosh, Commented Dec 12, 2016 at 8:27
@Tosh No, I didn't rewrite the SXSSFWorkbook class. If apache doesn't implement StreamingOutput then is there any other way to write the StreamingOutput object into excel fil? By other way i mean any intermediate Object which can be convertable from StreamingOutput and can be used by SXSSFWorkbook to write into excel. — Yogesh Patel
– Yogesh Patel, Commented Dec 12, 2016 at 8:35
@YogeshPatel I didn't notice till it was too late to fix my comment. There is nothing in your code that necessitates the workbook, you could easily remove it and just save your streaming output to file. Assuming your streaming output is already properly formatted there is no reason for the typecast. If you need that for some reason that isn't obvious, you should either rewrite your question or create a new post for how to format your output to an xml file. — Tosh
– Tosh, Commented Dec 12, 2016 at 9:02

CodeRunner · Accepted Answer · 2016-12-12 08:54:45Z

2

StreamingOutput write method must be overridden to return the output object. Here is an example :

public Response streamExample(){
        StreamingOutput stream = new StreamingOutput() {
            @Override
            public void write(OutputStream out) throws IOException, WebApplicationException {
                Writer writer = new BufferedWriter(new OutputStreamWriter(out));
                for (int i = 0; i < 10000000 ; i++){
                    writer.write(i + " ");
                }
                writer.flush();
            }
        };
        return Response.ok(stream).build();
    }

Please check the Docs of Streaming output and here for more information

answered Dec 12, 2016 at 8:54

CodeRunner

1471 silver badge9 bronze badges

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

Collectives™ on Stack Overflow

Write into excel file using StreamingOutput object. (java.lang.ClassCastException)

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related