Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to do something like this
for i=1 to 3
sheet='Sheet' <- here I want sheet to be a 'Sheet1' in first iteration, 'Sheet2' in second etc
LOAD field1,
field2,
field3
FROM
(ooxml, embedded labels, table is $(sheet));
next i
How can i do it?
Try this...
for i=1 to 3
let vSheet = 'Sheet$(i)';
LOAD Test
FROM
Book1.xlsx
(ooxml, embedded labels, table is $(vSheet));
next