Java: byte[] Array to Excel to BLOB

Question

i have an byte[] array that needs to be converted into an valid excel spreadsheet. After converting the byte array, the excel spreadsheet must be cached into the database preferably as BLOB.

First I tried to create an WritableWorkbook with:

WritableWorkbook workbook = Workbook.createWorkbook(byteArrayOutputStream);
...
workbook.write();

This would work fine for me, but i have no idea how to store a workbook as BLOB into the database. Is it even possible? Or is there another way?

Optionally: Instead of the byte[] array I also could use a deserialized object.

Workbook API: http://jexcelapi.sourceforge.net/resources/javadocs/2_6_10/docs/jxl/Workbook.html

You should at least mention what project you are using in your code sample, best put it in tags too. — MarianP
– MarianP, Commented Aug 22, 2011 at 14:47
of course, that information is missing. i work with jxl, an excel java api. (added to the tags) jexcelapi.sourceforge.net/resources/javadocs/2_6_10/docs/… — 0xPixelfrost
– 0xPixelfrost, Commented Aug 23, 2011 at 6:45

Jim Garrison · Accepted Answer · 2011-08-22 14:45:16Z

4

The jdbc method PreparedStatement#setBlob() takes an InputStream as the data source argument. Just create a ByteArrayInputStream over the buffer of your byteArrayOutputStream and pass that to setBlob().

answered Aug 22, 2011 at 14:45

Jim Garrison

87k20 gold badges161 silver badges196 bronze badges

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

Comments

Vishesh · Accepted Answer · 2011-09-14 07:27:28Z

1

There is no method in jxl from where we can get outputstream or the byte array from the writableWorkSheet.

answered Sep 14, 2011 at 7:27

Vishesh

1111 gold badge1 silver badge5 bronze badges

Collectives™ on Stack Overflow

Java: byte[] Array to Excel to BLOB

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related