This content has been marked as final. Show 3 replies
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?