wood burning stoves 2.0*
The moose likes Other Open Source Projects and the fly likes POI: Modify the spreadsheet after retrieving if from a blob Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Products » Other Open Source Projects
Bookmark "POI: Modify the spreadsheet after retrieving if from a blob" Watch "POI: Modify the spreadsheet after retrieving if from a blob" New topic
Author

POI: Modify the spreadsheet after retrieving if from a blob

Kenneth Rowe
Greenhorn

Joined: Nov 13, 2009
Posts: 5
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
Bartender

Joined: Oct 14, 2005
Posts: 18643
    
    8

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
Greenhorn

Joined: Nov 13, 2009
Posts: 5
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
Bartender

Joined: Oct 14, 2005
Posts: 18643
    
    8

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.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: POI: Modify the spreadsheet after retrieving if from a blob