Hi All,
I have updated my Studio and the latest version is 2023.2.0 Community Edition.
When I’m using Excel Activities to read and write data, It is creating a copy of that excel file and throwing an error :
Sample.xlsx is read only and can not be overwritten. It has been saved as Sample(1).xlsx
Could someone help me with the changes please.
Thanks in Advance
Anil_G
(Anil Gorthi)
March 8, 2023, 8:27am
2
@Vaishnav_Tej
Can you please use modern excel activities instead of the classic activities…May be that is causing the issue
Cheers
Because your excel opening in read only mode
Use kill excel process before that activity use read range worksheet activity rather then excel application scpe
Anil_G
(Anil Gorthi)
March 8, 2023, 8:33am
6
@Vaishnav_Tej
You can check in excel application scope if you have selected read only option
Cheers
Anil_G
(Anil Gorthi)
March 8, 2023, 8:39am
8
@Vaishnav_Tej
Did you try with using modern activities?
And can you check the file if it s in readonly mode…
You can check that by opening file and go to options and see if read only is selected…
Cheers
But I’m performing multiple actions in single excel file. So I want to use Excel Application Scope.
Yes I tried using modern activity. But Microsoft version is not supporting in my system.
Anil_G
(Anil Gorthi)
March 8, 2023, 8:43am
11
@Vaishnav_Tej
Can you try saving the excel file using save as and try…may be the file is corrupted…
Also open task manager and check if any background excel is open…Microsoft excel is what you will find as process
Cheers
Can you tell the navigation. I’m not finding that option. GEnerally in properties it is unchecked
Anil_G
(Anil Gorthi)
March 8, 2023, 8:47am
13
@Vaishnav_Tej
Open the file…then click on file from
The top menu.and check there for these details…
And can you confirm if you have microsoft excel installed?
If not please use workbook activities as excel application acope is supported for microsoft excel only and not for wps office
Cheers
I have Microsoft Excel 2007
Also I’m using WPS. Before it used to work with WPS.
After Updating to 2023 version, It’s throwing such errors
Anil_G
(Anil Gorthi)
March 8, 2023, 9:58am
15
@Vaishnav_Tej
May be its a one of case it worked…But as per official documentation wps is not supported in excel actviites and only microsoft excel is supported
so better try using workbook activities which does not required any office to be installed
cheers
1 Like
Hey @Vaishnav_Tej ,
After the read range in the excel scope close the workbook pass out argument like this
After that in new excel scope use the write range it will solve your issue.
Cheers.
Hi @Vaishnav_Tej ,
This issue may be caused by the Protected View setting in Excel, which can prevent the file from being overwritten. To resolve this issue, you can try disabling Protected View in Excel:
Open Excel and go to the “File” tab.
Select “Options” and then select “Trust Center”.
Click on “Trust Center Settings” and then select “Protected View”.
Uncheck the boxes for “Enable Protected View for files originating from the Internet” and “Enable Protected View for files located in potentially unsafe locations”.
Click “OK” to save the changes.