/build/static/layout/Breadcrumb_cap_w.png

Scripting Question


How to append extra rows to an existing Excel file

05/08/2014 3369 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

Comments


All Answers

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).

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.
 
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