I want to do something like this
for i=1 to 3sheet='Sheet' <- here I want sheet to be a 'Sheet1' in first iteration, 'Sheet2' in second etcLOAD field1, field2, field3FROM[C:\Documents and Settings\paha\My Documents\Book11.xlsx](ooxml, embedded labels, table is $(sheet));next i How can i do it?
for i=1 to 3
let vSheet = 'Sheet$(i)';
LOAD TestFROMBook1.xlsx(ooxml, embedded labels, table is $(vSheet));
Retrieving data ...