How to save A1 in variable???

[mechanic98]

hi, i want to save A1 that read from sheet in the variable EX: String S1=A1(that read from sheet...)

Serial.println(F("GET Data from cell 'A1':")); if (client->GET(url3, host)){ ++connect_count; }

[electronicsguy]

at the moment, you cannot. Will be releasing a new library soon which will make this possible, along with a bunch of other improvements.

[mechanic98]

can you see this url and help to me?

On Sat, Oct 7, 2017 at 9:47 AM, Sujay Phadke notifications@github.com wrote:

at the moment, you cannot. Will be releasing a new library soon which will make this possible, along with a bunch of other improvements.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/electronicsguy/ESP8266/issues/43#issuecomment-334913702, or mute the thread https://github.com/notifications/unsubscribe-auth/AM000j-IjE8jQUwi5LbAqzghXkO4_PIQks5spxeIgaJpZM4PuKPR .

[mechanic98]

can you see this url and help to me? https://github.com/JhonControl/ESP8266_GPIO_GoogleSpreadsheet/issues/1

On Sun, Oct 8, 2017 at 1:46 PM, HOSSEIN IZADI izadi.pc@gmail.com wrote:

can you see this url and help to me?

On Sat, Oct 7, 2017 at 9:47 AM, Sujay Phadke notifications@github.com wrote:

at the moment, you cannot. Will be releasing a new library soon which will make this possible, along with a bunch of other improvements.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/electronicsguy/ESP8266/issues/43#issuecomment-334913702, or mute the thread https://github.com/notifications/unsubscribe-auth/AM000j-IjE8jQUwi5LbAqzghXkO4_PIQks5spxeIgaJpZM4PuKPR .

[lorol]

@mechanic98 Meanwhile (until the author releases nice new version) you can check my workaround here: https://github.com/lorol/Googlesheet_DHT_simple

[mechanic98]

hi thanks for reply. 🙏 your code is very good. but i give error whet code go to "Write to GS" (https://github.com/lorol/Googlesheet_DHT_simple) this is my serial monitor : https://pastebin.com/rVXux49i

this is my google sheet adress: https://docs.google.com/spreadsheets/d/1fKZXZ2m-wa9sV9OcCZ9AFa3THpvaPREM8k_mcU--NM4/

when i run this in browser get this error: https://script.google.com/macros/s/AKfycbxRzkMt87iyiyU9EDY6REoRDpl5C9oHdjVyCSF6A4QN7jkNMGHD/exec?par1=0.4&par2=2.1&par3=8

error: {"result":"error","error":{"message":"Invalid argument: id","name":"Exception","fileName":"Code (DHT11)","lineNumber":41,"stack":"\tat Code (DHT11):41 (handleResponse)\n\tat Code (DHT11):24 (doGet)\n"}}

thanks a lot

On Mon, Oct 9, 2017 at 12:34 AM, lorol notifications@github.com wrote:

@mechanic98 https://github.com/mechanic98 Meanwhile (until the author releases nice new version) you can check my workaround here: https://github.com/lorol/Googlesheet_DHT_simple

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/electronicsguy/ESP8266/issues/43#issuecomment-335038442, or mute the thread https://github.com/notifications/unsubscribe-auth/AM000r8eApDYJD0UhvNIMyOU4HGdbm6dks5sqTjbgaJpZM4PuKPR .

[mechanic98]

hi I give now only an error:

------S: 60 E: 0 C: 7 T: 23.50 H: 23.90 I: 192.168.1.2

Write to GS {"result":"error","error":{"message":"Invalid argument: id","name":"Exception","fileName":"Code (DHT11)","lineNumber":41,"stack":"\tat Code (DHT11):41 (handleResponse)\n\tat Code (DHT11):24 (doGet)\n"}}

[mechanic98]

wow its work !!!!! i am so hapyy :dancing_men: i change this: var doc = SpreadsheetApp.openById(SCRIPT_PROP.getProperty("key")); to: var ss = SpreadsheetApp.openById('19L6_RAxkS3tihfcW_TwHuKAusHXCiEwJOECiNuYD-d0'); and program run without any error :D

[JhonControl]

Excellent implementation of @lorol . perfect @mechanic98 , you have solved the problem and have created your application.

regards