Hi all, I'm pretty new to using the Google APIs, so pardon me if this isn't the right forum for this question. Having said that...
I'm trying to read spreadsheets from my Google account using the Python library that is described at (http://code.google.com/apis/ spreadsheets/data/1.0/developers_guide_python.html). I'm using the single-user programmatic login, which is enough for my purposes, and I've got my script reading data successfully. However, there's one worksheet in which the column headers do not appear correctly, and I suspect it's because its data is a pivot table drawn from another sheet. (I created the pivot table originally via the browser, not the API.) Here's the essence of what I'm doing: client = gdata.spreadsheet.service.SpreadsheetsService() client.email = ... client.password = ... client.ProgrammaticLogin() theFeed = client.GetListFeed(spreadsheetID, worksheetID) Instead of the human-readable column headers I see when looking at the worksheet in my browser, when I access the records of theFeed, the script is showing me headers like "_chk2m", "_cn6ca", "_cokwr", and so on. So my questions are: Is there a way to access my human-readable headers from the script? Or, if not, could you point me to a way I could obtain an equivalent pivot table from my database using a Python (or PHP) library? [FWIW, I'm using the spreadsheet to record data during classes I teach; the pivot table is primarily for my own viewing, but I'm trying to write a script that proxies the data to let each student see only the individual row that corresponds to them in the pivot table. If you know of a screamingly obvious solution that's way simpler, I'd love to hear about it!] Thanks, Jordan
