topic Ignore Hidden Rows In Excel in QlikView https://community.qlik.com/t5/QlikView/Ignore-Hidden-Rows-In-Excel/m-p/286272#M712784 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I am pulling in a number of spreadsheets from Excel and there are values in hidden rows that I need to ignore.&nbsp; As there are a large number of locked workbooks it will take a long time to modify the spreadsheets to mark the visible rows.</P><P></P><P>Is there a way in the load script to simply skip over rows that have been hidden?</P><P></P><P>- Dan</P></BODY></HTML> Tue, 10 May 2011 09:07:19 GMT 2011-05-10T09:07:19Z Ignore Hidden Rows In Excel https://community.qlik.com/t5/QlikView/Ignore-Hidden-Rows-In-Excel/m-p/286272#M712784 <HTML><HEAD></HEAD><BODY><P>Hi there,</P><P></P><P>I am pulling in a number of spreadsheets from Excel and there are values in hidden rows that I need to ignore.&nbsp; As there are a large number of locked workbooks it will take a long time to modify the spreadsheets to mark the visible rows.</P><P></P><P>Is there a way in the load script to simply skip over rows that have been hidden?</P><P></P><P>- Dan</P></BODY></HTML> Tue, 10 May 2011 09:07:19 GMT https://community.qlik.com/t5/QlikView/Ignore-Hidden-Rows-In-Excel/m-p/286272#M712784 2011-05-10T09:07:19Z Ignore Hidden Rows In Excel https://community.qlik.com/t5/QlikView/Ignore-Hidden-Rows-In-Excel/m-p/286273#M712785 <HTML><HEAD></HEAD><BODY><P>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...</P><P></P><P>Regards</P><P></P><P>Fernando</P></BODY></HTML> Tue, 10 May 2011 17:14:05 GMT https://community.qlik.com/t5/QlikView/Ignore-Hidden-Rows-In-Excel/m-p/286273#M712785 fernandotoledo 2011-05-10T17:14:05Z Ignore Hidden Rows In Excel https://community.qlik.com/t5/QlikView/Ignore-Hidden-Rows-In-Excel/m-p/286274#M712786 <HTML><HEAD></HEAD><BODY><P> 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!</P></BODY></HTML> Mon, 16 May 2011 13:00:28 GMT https://community.qlik.com/t5/QlikView/Ignore-Hidden-Rows-In-Excel/m-p/286274#M712786 2011-05-16T13:00:28Z Ignore Hidden Rows In Excel https://community.qlik.com/t5/QlikView/Ignore-Hidden-Rows-In-Excel/m-p/286275#M712787 <HTML><HEAD></HEAD><BODY><P>I'm glad I could help!</P><P></P><P>Best regards,</P><P></P><P>Fernando</P></BODY></HTML> Tue, 17 May 2011 12:02:00 GMT https://community.qlik.com/t5/QlikView/Ignore-Hidden-Rows-In-Excel/m-p/286275#M712787 fernandotoledo 2011-05-17T12:02:00Z