How to append extra rows to an existing Excel file
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
Answers (1)
Please log in to answer
Posted by:
anonymous_9363
10 years ago
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).
Comments:
-
Hi, Is it possible to provide any code in java. - rkiran57 10 years ago
-
Sorry, no, I don't do Java. - anonymous_9363 10 years ago
