How to paste data in excel file

Help Studio
1

Hi All,

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?

image
image1183×262 16.1 KB

2

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.

image
image1198×179 13.2 KB

3

@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.

1 Like
4

hi @bryant.macciano ,

Sharing a below video - see if it helps

1 Like
5

thanks a lot! it helps!

6

this is great! it works! thansk a lot

1 Like
7

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.