api google sheets

[fdaniele]

Good morning and happy new year.

someone knows how we can read/write a google sheets ?

via api? someone have experiences? 

thanks 

Daniele

[fdaniele]

No one?

[Rafa Pabd]

http://www.fivetechsupport.com/forums/viewtopic.php?f=3&t=34904&sid=bd17f66a8accac8503df57df61c3634b#p207521

[Rafa Pabd]

Google Libs author is Mr. Cristóbal Navarro

[jparada]

Hi,

I was doing some testing and had success write in a google spreadsheet, based on this article
https://www.jhanley.com/google-oauth-2-0-testing-with-curl-version-2/

but I had to mix things up with harbour and python

I attach the example that worked for me, I hope it can be useful or give you an idea, in any case if you or someone else
can improve the example or make it work without python I hope you can share.

spreadsheetID refers to the id of the google spreadsheet.
Hoja1!A1 refers to the name of the google spreadsheet and A1 to the range

rename  google.txt to google.zip then c.txt to c.bat, g.txt to google.prg 

Regards,
Javier

[fdaniele]

thanks mr. jparada

very nice code

happy new year

Regards

Daniele

[fdaniele]

Hi  mr. jparada, Hi all

i found an exe from windows cli and linux for copy files from/to gmail

https://github.com/prasmussen/gdrive

works vey well, i hope is usefull to someone

regards

[fdaniele]

Dear mr.  Javier, i not forget my promise

some days ago master Linares has publisced a project for use python with harbour (!) (but maybe you already know)

I wanted to let you know, if I can read the google sheets I will inform you :-)

regards and always thanks

Daniele

Il giorno mercoledì 5 gennaio 2022 alle 02:59:51 UTC+1 jparada ha scritto: