Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Ignore Hidden Rows In Excel

Hi there,

I am pulling in a number of spreadsheets from Excel and there are values in hidden rows that I need to ignore.  As there are a large number of locked workbooks it will take a long time to modify the spreadsheets to mark the visible rows.

Is there a way in the load script to simply skip over rows that have been hidden?

- Dan

1 Solution

Accepted Solutions
fernandotoledo
Partner - Specialist
Partner - Specialist

Hidden lines are not "marked" to QlikView to identify them. It´s not an atribute from the data, but from the visualization in excel. So, im afraid you´ll have to mark all those sheets...

Regards

Fernando

View solution in original post

3 Replies
fernandotoledo
Partner - Specialist
Partner - Specialist

Hidden lines are not "marked" to QlikView to identify them. It´s not an atribute from the data, but from the visualization in excel. So, im afraid you´ll have to mark all those sheets...

Regards

Fernando

Not applicable
Author

Fernando - thanks for you reply. We were able to find an alternative list within the spreadsheet in the end fortunately. But I know now for next time!

fernandotoledo
Partner - Specialist
Partner - Specialist

I'm glad I could help!

Best regards,

Fernando