Reading Excel files in Qlikview

[prachisangewar1]

Hi,

I am reading excel files as my source to generate QVDs. I am capturing the excel row no. to do some mapping.

Some files have NULL rows, which qlik excludes while reading and the row no. it popluates is not correct.My requirement is to also capture the null rows and with the correct row number.

I have used rowno() and Recno() function. Both do not solve the purpose. Please advise if any other workaroung or solution for this scenario.

Thanks

[prachisangewar1]

Understand. is there any way i can read from row 2 as the header ? I tried to modify the script a bit but gives error.

Thanks

[prachisangewar1]

ex