POI: Modify the spreadsheet after retrieving if from a blob

[Kenneth Rowe]

This problem has been killing me for several weeks. Essentially, I am retrieving a spreadsheet from an oracle database where it is stored as a blob. In the servlet that does this, I also want to add to the contents of the spreadsheet after the retrieval.

Any suggestions or sample code would be MUCH appreciated.

[Paul Clapham]

Which part of that contains your problem? The part about getting a spreadsheet out of a BLOB? The part about modifying it? Some other part about how to deal with it after that?

[Kenneth Rowe]

the stuff I posted works fine. After that, I need to get a handle to the workbook and add "hello from Ken" to some cell on the spreadsheet that I retrieve from the database.

Thanks!

[Paul Clapham]

Okay then. It's hard to track down, but the POI project does have a page of examples for Excel. Here's a link to it: HSSF and XSSF Examples. And there's a very long page which is like an FAQ: Busy Developers' Guide to HSSF and XSSF Features. And do follow the "HOWTO" link near the top of that page.