Excel Upgrade - Notebook issues

Help StudioX
,
1

I had a working bot on Friday, however over the weekend a new Excel (Microsoft 365) was upgraded on my computer. In this bot, I have variables being assigned with data from the Project Notebook, which worked fine on Friday, but no longer are reading the data from the Notebook. I validated this, by adding message boxes, and the message boxes are just showing the formula instead of the value from the notebook.

Thanks in advance for your help!

Steve

2

Hello @RPANovice1

Which activities are you using for reading data from the Excel file?
There are separate activites for reading “values” and for reading formulas.

Regards
Soren

3

The image shows a UiPath interface where a variable "PSR_Project" is being set to the value from an Excel cell, with the exact cell referenced being formatted using the Cognos_Counter variable. (Captioned by AI)
The image shows a UiPath interface where a variable "PSR_Project" is being set to the value from an Excel cell, with the exact cell referenced being formatted using the Cognos_Counter variable. (Captioned by AI)618×415 10.3 KB

Here is an example of one the items…

4

Hello Steve,
Do you have the same thing in the advanced editor when you clic on the + sign?

5

I do… except it starts with String.

image
image708×107 3.84 KB

6

Which StudioX version do you have?
What is the type of your PSR_project variable?

7

2022.4.6
It was created as a text variable, but shows as a string variable.

8

What if you leave only this : Project_Notebook.Sheet(“Scratchpad”).Cell(string.Format(…)) and remove the double quote? and maybe with a .toString at the end