05/08/2014 3267 views

How to append extra rows to an existing Excel file in java.

I tried POI and JExcel but both are working for creating new files but not to add to existing one.

0 Comments   [ + ] Show comments


All Answers


The object model for Excel is pretty straightforward and well documented on MSDN.

From memory, you need to use the .Cells method of the Worksheet object. Finding the next empty cell will be the challenge (unless you already know its cell reference, of course) but there is VBA code out there for that, which you can adapt to suit (since the object/property/method syntax will be the same).

Answered 05/09/2014 by: VBScab
Red Belt

  • Hi, Is it possible to provide any code in java.
    • Sorry, no, I don't do Java.