How do I get .text of an Excel cell instead of .value

Help
,
1

Hi!

I am trying to fetch the text of an excel cell instead of the value. The readCell activity from excel scope is getting the value, which is not what I want. I have found the programming way to do it, which is

But how can I implement this into Studio? I am not allowed to edit the Excel sheet, since its pwd protected. Othervise i could have fixed the problem inside Excel itself.

If more explanation is needed give me a message :slight_smile:

2

hi @Adrian_Vigdal. have you found a solution to this? and if so, do you remember it? i am facing the same issue and i can’t seem to figure out how to go about it. thank you!

3

Hello, nope, never found a solution so had to get a workaround using the password of the excel file and open the actual file :slight_smile: