How can I convert POI HSSFWorkbook to bytes?

JavaApache Poi

Java Problem Overview

Calling Simple toBytes() does produce the bytes but exel throws Warning.

> Lost Document information

Googling around gave me this link and looking at Javadocs for worksheet and POI HOW-TO say similar things . Basically I can not get Bytes without loosing some information and should use the write method instead.

While write does work fine I really need to send the bytes over . Is there any way I can do that ? That is get the bytes with out getting any warning .

Java Solutions

Solution 1 - Java

As that mailing list post said

>Invoking HSSFWorkbook.getBytes() does not return all of the data necessary to re- construct a complete Excel file.

You can use the write method with a ByteArrayOutputStream to get at the byte array.

ByteArrayOutputStream bos = new ByteArrayOutputStream();
try {
    workbook.write(bos);
} finally {
    bos.close();
}
byte[] bytes = bos.toByteArray();

(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.)

Solution 2 - Java

How about:

ByteArrayOutputStream baos = new ByteArrayOutputStream();
workbook.write(baos);
byte[] xls = baos.toByteArray();

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

Categories
Recommended Java Solutions
Recommended Apache Poi Solutions

Previous Solution:

ab (Apache Bench) error: apr_poll: The timeout specified has expired (70007) on Windows

Apachebench

Next Solution:

Installing Sublime Text's command line tool 'subl' in terminal, permission denied?

TerminalOsx LionSublimetext

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionShahzebView Question on Stackoverflow
Solution 1 - JavaJörn HorstmannView Answer on Stackoverflow
Solution 2 - JavaGagravarrView Answer on Stackoverflow