excel files with different sheet names

[nareshthavidishetty]

Hi how to load multiple excel files with different sheet names

[avinashelite]

check this article:

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

[sunny_talwar]

Check this and see if this helps

for Each file in 'A' , 'B'

Table$(file):

LOAD *

FROM

Community_205639.xlsx

(ooxml, embedded labels, table is $(file));

NEXT

[nareshthavidishetty]

Hi Avinash i already tried that but wont work