This week's book giveaway is in the OCPJP forum.
We're giving away four copies of OCA/OCP Java SE 7 Programmer I & II Study Guide and have Kathy Sierra & Bert Bates on-line!
See this thread for details.
The moose likes Java in General and the fly likes trying to edit the data in an excel file  Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCA/OCP Java SE 7 Programmer I & II Study Guide this week in the OCPJP forum!
JavaRanch » Java Forums » Java » Java in General
Bookmark "trying to edit the data in an excel file  " Watch "trying to edit the data in an excel file  " New topic
Author

trying to edit the data in an excel file

caro sm
Greenhorn

Joined: Dec 15, 2012
Posts: 3
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

Joined: Dec 15, 2012
Posts: 3
you are right i will get use to do that...thank you
Tony Docherty
Bartender

Joined: Aug 07, 2007
Posts: 2332
    
  50
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

Joined: Dec 15, 2012
Posts: 3
the changes are done and outputed but not saved to the old excel file
Tony Docherty
Bartender

Joined: Aug 07, 2007
Posts: 2332
    
  50
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:
 
Consider Paul's rocket mass heater.
 
subject: trying to edit the data in an excel file