I have an excel sheet with 12 columns and 20 rows(including header).
I want to add an empty row before the header row,
I used invoke method with these parameters, but the row got added after the header row.
Thank you
I have an excel sheet with 12 columns and 20 rows(including header).
I want to add an empty row before the header row,
I used invoke method with these parameters, but the row got added after the header row.
Thank you
Header is not a row…header is header itself…there cannot be something before header
Also you need this on excel!? Then just start writing from the row after the blank row
Cheers
In DataTable, you can’t add a blank row above the headers. Instead write your range in excel from Row 2 so this way you will have blank row before header.
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.