Detect if an Excel file is read-only

[Camille361 (Camille)]

Hi guys !
I found different topics concerning this question, but none have been solved.
I would like to detect if my excel file is read-only, is it possible ? And in the case the read-only button is checked is it possible to uncheck it ?

I found this answer on another topic but I don’t understand it :
" You can build in a check for it with ‘Element Exists’. As a selector make sure that the ‘Read Only’ part is in the name of the window.
For example, use the following selector: <wnd app=‘excel.exe’ cls=‘XLMAIN’ title=‘Excel Sheet - Read-Only*’ />
‘Element Exists’ will only return ‘true’ if Read-Only is in the name of the file. If it does, you can handle it as you wish."

Can you help me with this please ?

Thank you !

[ppr (Peter Preuss)]

@Camille361

" You can build in a check for it with ‘Element Exists’. As a selector make sure that the ‘Read Only’ part is in the name of the window.
For example, use the following selector: <wnd app=‘excel.exe’ cls=‘XLMAIN’ title=‘Excel Sheet - Read-Only*’ />
‘Element Exists’ will only return ‘true’ if Read-Only is in the name of the file. If it does, you can handle it as you wish."

if excel is opened in read-only mode then this is marked on the title. So the mentioned strategy was looking for this token to decide the open mode

[Camille361 (Camille)]

Ok ! Thanks ! I didn’t notice that it was written automatically in the tittle … ^^

[Camille361 (Camille)]

I have some problem to use the formula in my project …

In my project, the user has to enter the name of the Excel file we want to work on. For example :

PATH = "C:\Desktop\Excel_file.xlsx"

So I do :

File_Name = Path.GetFileName(PATH)

and I modify the formula like this :

<wnd app=‘excel.exe’ cls=‘ + PATH + "’ title=‘ + File_Name +" - Read-Only*’ />

But that’s not working because the File_Name I use doesn’t contain the “Read-Only” words.
So how can I do to directly get the name of the opened file with the “Read-Only” words ?

[ppr (Peter Preuss)]

I would suggest to explore what excel is adding for a read only open in your language. I guess it is French, right?

[Camille361 (Camille)]

Yes I know. The only difference in French is that “Read-Only” is replace by “Lecture Seule”.
But that’s not working …

[ppr (Peter Preuss)]

@Camille361
try one thing:
Use variables in selectors as described here:

How to use variables in selectors in Studio (dynamic selectors) without string manipulation!

This tutorial will teach you how to easily use variables in your selectors. In other words, we will be making dynamic selectors without the use of the old method of concatenating strings. How cool is that! For the purpose of this tutorial, I will make 1 click in the Notepad app. Feel free to also reference our documentation here. Let’s begin! 1. First, we will indicate the element we want to click on. In this case, it will be File menu in Notepad: [image] This results in the…

the benedfit is, that with a default value the selector can be validated along the dynamic part

Remove the cls from selector cls=‘+ PATH+’

wnd app=‘excel.exe’ title=‘*{{FileName}}*Read-Only*’ />