Ignore Hidden Rows In Excel

[#1]

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

[fernandotoledo · Accepted solution]

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

[#3]

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]

I'm glad I could help!

Best regards,

Fernando