3 Replies Latest reply: May 17, 2011 8:02 AM by Fernando Toledo RSS

    Ignore Hidden Rows In Excel

    Daniel Eve

      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