Hi, I am trying to write an application to update google spreadsheet via the API. I tried python first and ran the example spreadsheetExample.py in gdata-2.0.17/samples/spreadsheets. It works fine for most things, but does not work for columns with underscores or uppercase. For example, if the header has a column "sales_amt" or "salesAmt", this API won't work.
I saw that the python API documentation is not well kept. So I tried Java API and followed the example in https://developers.google.com/google-apps/spreadsheets/#adding_a_list_row Now it adds a new line even if the header has uppercase, but it does not work if the header has any underscores in it. For example, it works for "salesAmt" but not for "sales_amt". So the problem does not completely go away. Are underscores special in spreadsheets protocol? Thanks -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
