Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I am trying to load data from multiple excel files, each file has around 10 sheets and I want to load one sheet that starts with a particular name and sheet name in all these excel files is not the same but starts with Output as prefix (ex: output1, output23, output_5 etc) and file names are month_Jan, month_Feb, month_mar etc
Is there a way I can load the data at single go
[FROM [lib://Connections (vtct_sbruton)/month*.xlsx]
(ooxml, embedded labels, table is output1);]
you have to use loop to load the data