This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan 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 Android Security Essentials Live Lessons this week in the Android 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: 2173
    
  47
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: 2173
    
  47
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:
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: trying to edit the data in an excel file
 
Similar Threads
Find column number by StringCellValue
Unable to refresh Excel formula using POI
How do i format a string to date
Apache HSSF - corrupt excel file
How can I analize Excel file with Apache POI?