I want to use the Write Range activity and write something under the last row of the excel file. I thought I can do it with assigning a variable with the value datatable.Rows.Count+2 and then Write Range with the range “B”+variable.ToString" and it says that the range doesn’t exist for some reason. How can I solve that or is there another way to write a range into the row after the last row of the Excel sheet?
I hope you can help me out!
Thank you in advance