Hi,
Basically i want to retrieve data from different column of single row in excel and store it in array, later split it to different parameter name like parameter1, parameter2..etc to use further in different script unit.
With the above code, it did not work, so tried with project.variables as below, but here i am facing error while adding normal variable itself. But i want to add different variable name like parameter1, parameter2...etc through loop where 1,2... are variables.
When you are using AddVariable method, you should pass variable type as a second argument, but you tried to assign the value. In your case you need:
Project.Variables.AddVariable("FPath", "String")
Project.Variables.FPath = "C:/"
