• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

POI: Modify the spreadsheet after retrieving if from a blob

 
Kenneth Rowe
Greenhorn
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21416
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 5
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Sheriff
Posts: 21416
33
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic