The moose likes Java in General and the fly likes How to Edit an Excel File with Java Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "How to Edit an Excel File with Java" Watch "How to Edit an Excel File with Java" New topic

How to Edit an Excel File with Java

Dave Elwood
Ranch Hand

Joined: Dec 27, 2002
Posts: 84
I have tried this library jxl.etc and found that it can *create* an excel file but
if you have an excel file file which already exists and want to modify it then you are out of luck.

Seems that you have Workbook objects and WritableWorkbook objects.

This last line is what doesn't work - sheet.change_the_value_in_a_Cell(strNewValue, strCellPosition);

If I work with Workbook, I can only read it as in the code above.
If I work with WritableWorkbook I can write something, but I have to create the workbook anew each time.

Aside from POI from apache is there any other way to modify an already existing Excel file??

I agree. Here's the link: http://aspose.com/file-tools
subject: How to Edit an Excel File with Java
Similar Threads
How to write a file to a directory
convert excel
Can we refresh the directory from middle of java code
importing data from database to excel sheet through JExcel Api
Writing to EXCEL -- Workbook.write() not working