• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

trying to edit the data in an excel file

 
caro sm
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hello...i'm a new member here
i'm trying to edit the data in an excel file
this the code i'm able to read and change data but not able to update the data
Any help ???
 
caro sm
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
you are right i will get use to do that...thank you
 
Tony Docherty
Bartender
Posts: 2953
59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Can you be more specific about what your problem is. Do you mean you can't update a cell value, formula etc or that you can't save your changes or is it something else altogether?
 
caro sm
Greenhorn
Posts: 3
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
the changes are done and outputed but not saved to the old excel file
 
Tony Docherty
Bartender
Posts: 2953
59
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
It's a while since I used POI but don't you just create a FileOutputStream and pass it to the workbook's write method(). Something like:
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic