Excel file open in read only

Help Assistant
, , , ,
1

Hello they,
I created a robot read Data from Pdf file after that write that data in Excel file
I used Excel file scope to open excel file and write range in it,
Almost time the robot works 100% but some time when robot try to open excel file it be read only so robot creates another one with the same name and adds (1) after its name and stopped with this error

“File C:\Users\m.Bakr\Desktop\55\Meals Counting Template Week End.xlsx is read only and can not be overwritten. It has been saved as file C:\Users\m.Bakr\Desktop\55\Meals Counting Template Week End(1).xlsx”

why this problem appears only some times and how can I solve it?

thanks

2

@Mohammed_Bakr

As this is happening at some intervals, so suggest keeping kill process before the Excel Application scope. This will make sure that any opened sessions of the files will be killed and reopen as a fresh session

Hope this may help you

Thanks

3

how can I kill process please ?

4

@Mohammed_Bakr

Use Kill Process activity and In properties-> Process Name as “EXCEL”

image
image831×303 7.87 KB

Hope this will help you

Thanks

5

thank you very much i tried it but the problem were not solved

I tried to make Excel Scope Visible and the problem is solved Now :grinning:
:grinning: