Loading Value from Single Cell in Excel to QlikView

[HareeshR]

I want to load data from multiple files, but just the data in G14 cell in all the files, along with file name.

Load G,

FileBaseName()

From test.xslx

(ooxml, no label, table is Sheet) WHERE RecNo()=14

This is not working. Any suggestions??? 

[marcus_sommer]

Try it with:

first 1 Load G as Field, FileBaseName() as File From test.xslx
(ooxml, no label, header is 14 lines, table is Sheet);

- Marcus