I have tried looking at Apache POI and JXL.
Is it possible to write to Excel objects such as an Excel table (Table name: Table1) like below:
Is there a java based excel API that I can use to write to a table.
Please note that the columns Sl#, Course# and DOB are specific data types. I have a pre-existing excel with tables.
the possible pseudo code would look something like this:
1. Get handle of the table Table1.
2. add a new row something like: handleOfTable1.addRow(“5″,”Jenifer”,”24″,”05 April 1975″);
The updated table would look like
Or is there a better way of achieving this?