Hi, I have a workflow which started with a 1) copy file where I copy an excel from folder A to B, and then 2) read said excel with a read range 3) add data rows into the datatable 4) write said datatable back into that excel.
But occassionally I would receive an error in step 4 saying that the excel is being used by another process. I’d open the file manually right after the error but the file is not being used. I’ve also tried putting a delay of 10secs after step 1 and then it worked. But I’d prefer not to hard code any duration into the workflow, does anyone has any idea on how to know when an excel is not being used by another uipath process and only start processing after knowing the file is ready?
Many thanks.