Hi all, how do i add empty row after each time my data is append to the new excel file ?
just use add data row activity and pass the null values respect length of columns after append range
after reading the read range data table you can use below add data row activity. it will create blank row and finally you can use append data range.
Hope it helps!!!
we can combine the datatable used for the append range along with the empty row.
Maybe it is cleaner when
- having no empty row after the data block
- adding dynamicaly an empty row on the begin
So we can use within the Append Range
dTable.AsEnumerable.Prepend(dTable.NewRow).CopyToDataTable
i run into an error for this
then you should tell us, what you had done and what is the error
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.