search

mobizt / ESP-Google-Sheet-Client

Arduino Google Sheet REST client library for Arduino
MIT License
80 stars 15 forks source link

Something wrong in range syntax #6

Closed DrWino closed 1 year ago

DrWino commented 1 year ago

First of all - thanks for an excellent tutorial. I was amazed how far I got. I set up the API and I was able to list, create and write Google sheets. Just wonderful - would never have got this far on my own.

Here is my problem: If I specify the spreadsheet as dataFilters1.add("a1Range","Sheet1!A1:A2") I get error:

"message": "Unable to parse range: Sheet1!B1:B3",

However if I change it to "A1:A2" I can read and write to the spreadsheet. What gives here ?

mobizt commented 1 year ago

You should read the Google documentation as this library was built based on Google APIs.

mobizt commented 1 year ago

You should read the REST API related to these functions.

mobizt commented 1 year ago

The range format is right if your sheet title is "Sheet1".

DrWino commented 1 year ago

You are right - it was in front of my face - Sheet was labelled New Sheet. I guess I was used to excel where the default is Sheet1. Renamed New Sheet to Sheet1 and all is well. Great contribution and great support.