I am working with a table that is using multiple rows on a Excel sheet that i am using as a template.
The issue is that i need to select the multiple rows that are being used for the table. Then i can organize the populated data accordingly and the my trips To and From it will make a copy of the table size to put all the data in.
For my previous excel sheets i have made everything was only in 1 row with the headers above the row so i would use the sheet.getRow
like this -
IRow template_row = sheet.GetRow(start_row);
Everything would be populated in this row.
How to select multiple rows i am not sure yet.