1st row always empty, when using Add Data Row to add into excel

Hi All,
I am facing this issue of getting 1st row always empty.
I have tried both properties

  1. ArrayRow
  2. DataRow


Did anyone face this issue before?


Not completely sure what “issue” you mean.
Try to be more specific.

First Row in the excel where I am writing back the Datatable is always empty.
Please refer to screen shot, number to row is empty

I suppose you use “WriteRange” activity to write the DT to excel, right?
In that case you need to check the way how you populate the DT and what is the initial content of the DT - if it is empty before you insert any record.