Variables and Values stored in Excel

[MikeC (Mike)]

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.

[muhammedyuzuak]

Hi @MikeC,

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

Regards,
MY

[MikeC (Mike)]

Hi,

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