I have extracted information from a website into ExtractDataTable. Rather than write the information into a spreadsheet, I want to write each cell of the ExtractDataTable directly into a series of variables. For example my ExtractDataTable contains:
Blue 4
Yellow 2
Green 5
I want to assign:
Var11 = Blue Var12 = 4
Var21 = Yellow Var22 = 2
Var31 = Green Var32 = 5
How would I do this, or am I just better off writing ExtractDataTable into a spreadsheet and reading the cells back into variables?
datatables and arrays/lists are made exactly for the purpose of avoiding using lots of variables (which you can not anyway if you don’t know the number and the list is dynamic)