In append activity i am trying to paste data in excel however excel sheet already has formula and protected sheet. Append trying to paste in non formula column i need the data to be pasted in formula column.
Hi @T_S,
You can use the Append Range activity in UiPath to add data to the end of a specified Excel spreadsheet. If the sheet does not exist, a new one is created with the name indicated in the SheetName field.
If you want to paste data in a formula column, you can use Write Cell activity in UiPath. You can specify the cell range where you want to paste the data and also specify the value you want to paste
Thanks,
Welcome to the community
Append range by default will append the data after the filled rows…as you have already formula filled it is appending after that
Instead use write range and paste the data from
The cel you need
Another way is to have the formula also in datatable and remove the formula from excel and use append range so that the data and formul are pasted as expected
Cheers
Hi,
The sheet which i wanted to append is protected and i don’t know the password and that is standard template where i cannot change.
I have multiple files that need to append in the template. I tried with write range it is not working correctly. Because it is overrides the old data on the sheet.