/build/static/layout/Breadcrumb_cap_w.png

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)

Posted by: anonymous_9363 9 years ago
Red Belt
0

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 9 years ago
 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ