Filename

Sat, 06 Jun 2015 15:40:46 GMT

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

Re: Filename

maxgro — Sat, 06 Jun 2015 16:53:14 GMT

did you try with no labels?

Directory;

LOAD A, B, FileName()

FROM

[Nuovo Microsoft Excel Worksheet.xlsx]

(ooxml, no labels, table is Sheet1);