Can't read sheets with Sort icons in the header

Jun 21, 2011 at 3:18 PM

If any cell in a sheet has a sort icon in it, the entire sheet is skipped when reading AsDataSet()

And when reading line by line with while Read, it seems to NOT want to start at row 0. i.e. I had an excel spreadsheet as the 2nd sheet in a workbook with 100+ columns (all of which had sorts) and 1000+ rows, and it started reading (successfully mind you) at row 911.

Jun 21, 2011 at 3:25 PM

I take the first part back. it seems that the 2nd sheet, no matter how many sheets there are, is ignored.

 

And while the sheet NAMES are loaded in the right order, the sheet DATA is loaded backwards!