Hello Madhu,
In your image I don't see any of the cells for Excel row 5 populated. If the entire row of a spreadsheet is null, you cannot detect it by RowNo() using the File Import Wizard of QlikView. It will simply not generate a row during load and in all senses, will be completely null.
However, in cases where you expect that spreadsheets may be populated with fully empty rows in the data areas and you want to track Row numbers exactly as they correlate to the source spreadsheet, convert your connection to the Excel ADO ODBC connection. This connection will faithfully record every row in the spreadsheet whether it has data or not.
https://community.qlik.com/servlet/JiveServlet/showImage/2-600201-65777/20140829_Spreadsheet_recno_b...
Re: Need to import blank lines from Excel Workbooks
