Variables and Values stored in Excel

Hi Guys,

Is it possible to create vars and values from an Excel file.
I can easily create the value this way but not the var.

Screenshot 2022-07-10 171656

Screenshot 2022-07-10 171715

Hi @MikeC,

You can add it using a loop. You can examine the image.



The variable name is “CompanyName” (Address A2), the value is “Amazon” (Address B2)

I would need the variable name as reference, not the address.
In assign I want below
CompanyName | Excel.Sheet(“Sheet1”).Cell(“B2”)

Not this way
Excel.Sheet(“Sheet1”).Cell(“A2”) | Excel.Sheet(“Sheet1”).Cell(“B2”)

Thanks :grinning: