I have an excel sheet with almost 1000 row
And after every single row i need uipath to save the changes in the file because if there are any error it will stop and will not save the changes
How it can be done
I have an excel sheet with almost 1000 row
And after every single row i need uipath to save the changes in the file because if there are any error it will stop and will not save the changes
How it can be done
Send hotkey ctrl + s after every update
Hi @AbdulmuizSindi,
If you are using excel application scope in properties AutoSave open check it
else use Send hotkey ctrl + s after updating the operations.
Another Method:
Use Read Range activity to get the data from the excel sheet to Data Table.
using for each row activity do the addition operation and update the value.
using Write range activity update the Data table in to the excel sheet.
Regards,
Arivu