POI: Modify the spreadsheet after retrieving if from a blob

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.

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?

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!

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.