i would like to know how can i add a new row with new data to an existing excel ?
i use read range to read the data table,
i create a dataRow = DataTable.NewRow
i count the number of row in it,
i assign several variable to the new row,
i use add row
And know how can i add that row at the end of DataTable?
i used append activity but it seems to copy the existing DT, copy it and paste next to it.