Do you want to know how to delete empty rows in Excel?
If your question is about deleting after load, you may try the following.
If your data has a key field which cannot be null or empty, you may filter the rows using the preceding load
LOAD * where Len(Trim([your key field])) > 0;
LOAD ..... From (Your Excel file);
By default Qlik Will not load empty lines, unless you have some null values.
Try with below code.
LOAD Customer, [Sales Order ID], ShipDate, Product, Sales, Quantity FROM [C:\Users\mashfaq\Downloads\Copy of Sales Orders.xls] (biff, embedded labels, table is [Sales Orders$]) where len(Trim(Customer)>0);
Let me know if that worked..