Filename

[#1]

Hi All,

I have an excel file with just column headers and blank rows. As there are just column headers present without any data, so it is fetching 0 rows

Is it possible to get the filename of such a file?

Thanks,

Asma

[maxgro]

did you try with no labels?

Directory;

LOAD A, B, FileName()

FROM

[Nuovo Microsoft Excel Worksheet.xlsx]

(ooxml, no labels, table is Sheet1);