Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
did you try with no labels?
Directory;
LOAD A, B, FileName()
FROM
[Nuovo Microsoft Excel Worksheet.xlsx]
(ooxml, no labels, table is Sheet1);