How to fetch Last row w/o fetching Entire Data from excel

[#1]

Hi Friends,

I had a requirement to fetch last Row alone from the excel. The problem here is, it takes long time to fetch entire data, so instead i need only Last Row to use it in QV Reporting, Plz help me..

[SunilChauhan]

LOAD num(data) as data,
     file,
      dd
FROM

(ooxml, embedded labels, table is Sheet1, filters(
Remove(Row, RowCnd(Interval, Pos(Top, 2), Pos(Bottom, 2), Select(1, 0)))
));

Check this using excel posted by me

and then

apply same on your excel file

hope this helps

[SunilChauhan]

see the attached  files

hope this help