Loading variables through Excel File

Anonymous — Fri, 24 Feb 2017 14:27:18 GMT

Hi All,

I am using an excel file to store all my variables in the application

But when I am trying to use these variables in my script I am facing some challenges.

I also tried to use $(variablename) but still no success

hereby attaching the excel file and the sample code

I am able to get the definition of these variables in text objects .

What I wish to achieve is using these variables in my script

IF (vCalToday)>=(vRangeDate1) and (vCalToday)<=(vRangeDate2) then

here if I use just vCalToday then it takes as it as literal and if I use $(vCalToday) ,it resolves the definition

but it does not give me a value which I need .

Please help me in getting the same.

Thanks and Regards,

Nishant Nadkarni

Re: Loading variables through Excel File

MK_QSL — Fri, 24 Feb 2017 14:39:47 GMT

Keep the excel file and qvw at same place..

Application_Variables:

LOAD VariableName,

VariableDefinition

FROM

Test_27.xlsx

(ooxml, embedded labels, table is Test);

Let vNoOfVariables = FieldValueCount ('VariableName') ;

For v = 0 to $(vNoOfVariables)-1

Let vName = Peek('VariableName',$(v),'Application_Variables');

Let $(vName) = Peek('VariableDefinition',$(v),'Application_Variables');

Next v

Drop Table Application_Variables;