Looking for a helper, example, tutorial or something to get LiveCode and Spreadsheet data working together

[Andrew Kluthe]

This has been a need for several people lately, (myself included).
SpreadLib is a commercial-only excel spreadsheet importing library being
worked on by Curry Kenworth. He has several other libraries in the works
regarding Spreadsheets; but, as far as I know, these were being worked on
at this time last year with no official release since then or an expected
release date any time soon. Also, this would not work with the community
edition of LiveCode 6.0

Other options I have seen are leveraging VBScript to interact with
MS-Office, and importing from a CSV or tab-delimited copy of the
spreadsheet data.

There were some threads recently in the list that discussed these options
in more detail. I wish I had a link handy for you right now.



On Fri, May 10, 2013 at 12:40 PM, Mark Rauterkus
<mark.rauterkus at gmail.com>wrote:

> Hi Gurus!
>
> I don't see anything -- even an example stack -- regarding the merging of
> Spreadsheet data to LiveCode.
>
> I don't want to do a full scale SQL database thing, but would love to have
> it work with OpenOffice spreadsheet or even a Google Doc Spreadsheet.
>
> How to get data from rows and columns from spreadsheet into LiveCode is
> first challenge.
>
> Later I can worry, or not, about saving back to the spreadsheet.
>
> Pointers welcome.
>
> Thanks.
>
> More insights:
> Using LC 6.0.1 on WIN.
> Have a job application form in a google document:
>
> https://docs.google.com/spreadsheet/viewform?formkey=dEdHNTdEZGhKUG5zYkFBZVUtU3FBQXc6MQ#gid=0
>
> The resulting spreadsheet isn't nearly as good looking as a LC app could
> deliver.
>
>
>
>
> Mark Rauterkus       Mark.Rauterkus at gmail.com
> _______________________________________________
> 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
>



-- 
Regards,

Andrew Kluthe
andrew at ctech.me