File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
Win a copy of Clojure in Action this week in the Clojure forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to Edit an Excel File with Java

 
Dave Elwood
Ranch Hand
Posts: 84
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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??

 
It is sorta covered in the JavaRanch Style Guide.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic