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

excel
studio

#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

https://msdn.microsoft.com/en-us/vba/excel-vba/articles/range-text-property-excel

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: