I am facing issues while writing to excel sheet.
In my automation we have an excel sheet which will be having many rows and we process each row data and after processing we will be updating status post processing a row in excel. I am seeing issue “You Can’t Perform This Action When The File Is Read Only” error message can i get help how i can fix this issue
Hi @amit_anand15 I have added a delay between 2 process of 2 sec and that’s not helping me
@Mantri Do i need to kill the session every time before i write to excel file ? Initially before start of my process i am killing all excel sessions post that my automation will read data from excel file and processing 1 records/row every time it updates status back to sheet.
Yes, its only 1 process. Below is the flow
Download file from a website which is .xlsx file loop through the file and process each record post processing updating back status of that row to processed.
We are seeing issue when updaing back status to processed.
This used to work some times and some times its geting failed with error menioned.
Thanks Amit, I figured out another wau to achieve that
I have assigned a variable and appended status of respective row processing and after completion of loop i have wrote a python pandas script and inserted this array data in pandas dataframe column and wrote to excel file.