Write byte array to excel file in java

You can use the write method with a ByteArrayOutputStream to get at the byte array. The close call is not really needed for a ByteArrayOutputStream , but imho it is good style to include anyway in case its later changed to a different kind of stream. In order to get a full excel file out, you must call the write OutputStream method.

If you want bytes from that, just give a ByteArrayOutputStream. Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams?

Collectives on Stack Overflow. Learn more. Ask Question. Asked 9 years, 9 months ago. Active 9 years, 9 months ago. Viewed 71k times. Shahzeb Shahzeb 4, 4 4 gold badges 26 26 silver badges 40 40 bronze badges. The code is working fine but the only problem is that each time for building an excel file from the dynamic values coming from a service, the excel content is overwriting onto a test.

Is there any way to build an excel in memory and pass the byte for downloading it instead of creating an external file " test. This method may be preferable as JXL is keeping the workbook in memory anyway, and only flushes it to he output stream when the workbook is closed.

Stack Overflow for Teams — Collaborate and share knowledge with a private group. Create a free Team What is Teams? Collectives on Stack Overflow. Learn more. Asked 5 years, 2 months ago. Active 9 months ago. Viewed 25k times. Alex Man Alex Man 4, 16 16 gold badges 74 74 silver badges bronze badges. Sign in to vote. I am trying to convert a byte array to an excel workbook. When I do this with Response. BinaryWrite renderedBytes ; it works fine and the file is as expeced.

Write arrBytes, 0, arrBytes. Length ; memStream. Seek 0, SeekOrigin. SerializationException: Binary stream '0' does not contain a valid BinaryHeader. Possible causes are invalid stream or object version change between serialization and deserialization. Is there a difference in how binary write and deserialize work?

How can I fix it? Tuesday, May 20, PM. Hi, Sorry for my first reply. Monday, May 26, AM.