how to load excel with hidden rows

[Aadhini]

In Excel Some Hidden Rows are there, but loading time  the whole data in uploaded, but i want the data without 

hidden rows values , want unhidden rows value only .

I want to read/upload value of the visible rows data's in the Excel.  

[robert_mika · Accepted solution]

There is not native solution in Qlik.

You can go to Excel create new column=Visible and either manually formula or any other method add 1 for visible rows

Then in Qlik use the Where statement like

Load *

From...

where Visible_Flag=1

[Aadhini]

But don't have  the permission to do the changes in the  excel 

[robert_mika]

So I'm not aware about any other methods.

Hiding rows is not the best idea.

Ask the owner to unhide..