I have a daily report to paste the data in this excel file like below and tomorrow if have to continue to paste the data right after today’s data. I tried to find the last row but it didn’t seem to read column name “Created”. I guess since it’s not in the first row. Any idea how to paste the data from this blank template and continuously adding the data afterwards?
this is where I have to continue the data after. The data amount is dynamic, so I can’t really use the fixed row number.
@bryant.macciano Hi. Try Read Range workbook with header unchecked to datatable. Assign Rownumber = datatable.RowCount+1 and write range any datatable with Cell value “A”+Rownumber.ToString(). Hope this helps.
hi @bryant.macciano ,
Sharing a below video - see if it helps
this is great! it works! thansk a lot
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.