Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Ignore Hidden Rows In Excel

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 Replies
fernandotoledo
Not applicable

Ignore Hidden Rows In Excel

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

Ignore Hidden Rows In Excel

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
Not applicable

Ignore Hidden Rows In Excel

I'm glad I could help!

Best regards,

Fernando