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

Mike Kerner MikeKerner at roadrunner.com
Fri May 10 12:57:07 CDT 2013


Mark,

The easiest thing to do is to export your spreadsheet as a .csv file or as
a .dbf file.

>From there, you can (easily) use LC to get the data, so before we go any
further, what do you want to do with the data in liveCode?  The answer to
that question will help determine the rest of the steps.


On Fri, May 10, 2013 at 1:52 PM, Andrew Kluthe <andrew at ctech.me> wrote:

> 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
> _______________________________________________
> 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