chriszarate / sheetrock

Quickly connect to, query, and lazy-load data from Google Spreadsheets.
https://chriszarate.github.io/sheetrock/
818 stars 122 forks source link

Column order changes when first row contains only numbers #141

Open ljfrancis opened 5 years ago

ljfrancis commented 5 years ago

The first row in the data I'm fetching contains only numbers not in numerical order that are to be a table header.

3152 | 3153 | 3151 | 3124 | 3135 | 3177 | 3146 More text data under each header

When doing a simple select 'A,B,C,D,E,F,G' the columns rearrange based on the numerical order of the first row. Adding letter prefixes prevents this sorting from happening. Has anyone found a solution to this?