Great question, that sparked the clue to resolve it in my head... In Google Spreadsheets, the columns indeed have headings A, B, C. But the first row also appears to be reserved and function something like a column name.
For instance in this spreadsheet, the first row looks more like a column name than just a first row. https://docs.google.com/spreadsheet/ccc?key=0AtEH2Kw9zfIodEQ2dFNFam9sdEFEZlVnNEV3ZEZMZEE&hl=en_US#gid=0 Here the query "SELECT B, COUNT(A) GROUP BY B" returns the values 'East', 'South', 'West' and 'Midwest. Interestingly, it does not return the value in the first row, (i.e. 'Region'). Which is good. I see now that the URL it generates and which I pass to Google Query Language appends the argument "&headers=1" When I uploaded the dataset, Google guessed (correctly) that the first row is a header, and made that a setting. So it's smart enough not to use the first row as a dataset. But it doesn't treat it as a column name either. It just knows to ignore the first row. -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
