NPOI Excel Select multiple rows

Question

Hello all,

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.