Reading data from Google Sheets

[Andre Alves Garzia]

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