Add an Empty row before the header

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

@Hansen_Clyde_Lobo

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

1 Like

@Hansen_Clyde_Lobo,

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.