Hi all, I have a process which uses excel to read data. It is not able to find the excel intermittently even though the file is present in the directory. If I restart the computer, it usually works but is an inconvenience and only started happening recently. Please advise of possible causes and how to fix them?
Read range workbook activity wont create an excel if its not avaiable, use excel application scope and check “create if not exists”
Regards,
Vinit Mhatre
Use Kill process to kill the excel before reading the excel
Check the excel bu using File exists activity
Check the datatable and variable values anything passing as null
Hi @Vinit_Mhatre, the file permanently exists in that location. It is there always when I restart the machine it works without any issue.
Will try @rlgandu. Thanks
@Anived_Mishra
Main.xaml (9.2 KB)
check the file for reference
Hey @Krishna_Raj says Document is Invalid.
@Anived_Mishra
task.zip (9.8 KB)