Creating a list variable

[#1]

Hey guys,

I have an excel WB with about 20 sheets, for each i need to use the same loading script,

is there a way to predefine a variable to hold a list of my sheet names so i can iterate over that list with a for loop load?

Thanks!

[Gysbert_Wassenaar]

See this discussion: Loading Multiple Excel Files and Multiple Excel sheets

[miguelbraga]

Hi Shahar Rosen,

If the sheets have a logical correlation you can create a for loop to read them and load values dinamically. Can you share a sample of your Excel file?

Regards,

MB

[#4]

Ok i actually managed to create a list variable like this:

SET vSheetList = 'salary', 'bonus', 'car'..... ;

and then i iterate over that list...

and that works just fine