aspose file tools*
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


Win a copy of Java 8 in Action this week in the Java 8 forum!
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: 18150
    
    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: 18150
    
    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
 
Similar Threads
Excel File opening
how to retrieve image from database?
Converting Blob to word
Error exporting Blob to File
hoe to retrieve image from MySql database?