I am using the Find First/Last Data Row activity however it stopped and the error the A0 doesn’t exist then I used if = 0 inside it I used assign to make the previous zero 2 however when I have just one row the BOT start writing the third row leaving the headers and the second row if I used 1 instead of 2 it write on the header
If YourDataTable.Rows.Count = 0
rowToWrite = YourDataTable.NewRow()
’ Use Find First/Last Data Row activity here to get the last data row.
’ Assign the result to the rowToWrite variable.
Hope this helps
If you want to get first row and last row you can try this
To get the first row
to get last row
you mean instead of using the Find First/Last Data Row activity?
It will give you the first row and last row
Just use assign activity
Its datatype is datarow
Its datatype is of system.data.datarow
And before to that use if activity
In then block use this assign activities