Using Excel, set row number as a varriable

Help Studio
1

I want to set the “read cell value” expression to have a variable in the row number that it searches for
image
I would have expected something like this to work, but it doesn’t know that “Row_Number” is a variable. how can I tell the expression that I have defined the variable and to replace it with the row number

2

Hi @corey.phelan

In the cell field give like below,

Excel.Sheet("Sheet1").Cell("A"+Row_Number.toString)

Hope it helps!!

3

Hello! thank you for the assist, I’m getting a different error now, which is more progress than I’ve been getting

image (1)

4

Which value you are reading from excel, could you share a screenshot… @corey.phelan

If the value is in number or double format then the SAP_Number will be in System.Double Datatype.
First, try change the SAP_Number variable to System.double datatype and run the bot.

Hope you understand!!

5

I figured it out, I hadn’t selected “Read Formatted cell”

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.