Reading data from Google Sheets

Mike Kerner MikeKerner at roadrunner.com
Wed Nov 14 09:06:08 EST 2018


There's also the mergGoogle external.

On Wed, Nov 14, 2018 at 12:37 AM Kaveh Bazargan via use-livecode <
use-livecode at lists.runrev.com> wrote:

> Thank you so much to both. And Andre, if you could write a blog post for
> every question I have it would help me a lot. ;-)
>
> Actually I think I had looked at the very helpful StackExchange page before
> for reading Google Sheets directly in R. I will try it and report back with
> any follow ups.
>
> Regards
> Kaveh
>
> On Wed, 14 Nov 2018 at 02:12, Andre Alves Garzia <andre at andregarzia.com>
> wrote:
>
> > Kaveh,
> >
> > There is a much easier way. I've just posted about it since it can be of
> > interest for others (there is a demo stack included):
> >
> >
> >
> http://andregarzia.com/2018/11/reading-google-sheets-data-from-livecode.html
> >
> > Basically, there are special URLs for retrieving a Google Sheet as a CSV
> > or a JSON. Much easier than parsing HTML or visible text.
> >
> > Cheers
> >
> > andre
> >
> > On 11/14/2018 12:46 AM, dunbarxx via use-livecode wrote:
> > > Hi.
> > >
> > > well the (very) short answer is that you can:
> > >
> > > put url "yourWebpageAddressHere" into temp
> > >
> > > What you get is the entirety of the html contents of a page. Others
> will
> > > tell both of us how to get the "visible" text, that is, the tab and
> > return
> > > delimited data, buried in all those tags.
> > >
> > > Craig Newman
> > >
> > >
> > >
> > > --
> > > Sent from:
> >
> http://runtime-revolution.278305.n4.nabble.com/Revolution-User-f278306.html
> > >
> > > _______________________________________________
> > > use-livecode mailing list
> > > use-livecode at lists.runrev.com
> > > Please visit this url to subscribe, unsubscribe and manage your
> > subscription preferences:
> > > http://lists.runrev.com/mailman/listinfo/use-livecode
> >
>
>
> --
> Kaveh Bazargan
> Director
> River Valley Technologies <http://rivervalleytechnologies.com/> • Twitter
> <https://twitter.com/kaveh1000> • LinkedIn
> <https://www.linkedin.com/in/bazargankaveh/>
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode



-- 
On the first day, God created the heavens and the Earth
On the second day, God created the oceans.
On the third day, God put the animals on hold for a few hours,
   and did a little diving.
And God said, "This is good."



More information about the use-livecode mailing list