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

[Mike Bonner]

The newer excel spreadsheets (after office 97 I think) store their data in
a compressed xml format.  Basically a zipped file with a bunch of linked
xml files in there.  While its beyond me (don't like xml) it might be
possible to reverse engineer things to get to whats needed.


On Fri, May 10, 2013 at 12:03 PM, <dunbarx at aol.com> wrote:

> Hi.
>
>
> Is your question really asking that LC be able to read an ".xls" file?
>
>
> Fancy libraries notwithstanding, if you have your spreadsheet in "txt"
> format, you can read that file directly, and simply load into a table
> field, datagrid, or whatever.
>
>
>
> Of course, even in ".xls" format, copying to the clipboard does wonders,
> albeit by hand.
>
>
>
> But I, too am yearning for something that will allow LC to read an Excel
> Workbook formatted spreadsheet.
>
>
> Craig Newman
>
>
>
>
> -----Original Message-----
> From: Andrew Kluthe <andrew at ctech.me>
> To: How to use LiveCode <use-livecode at lists.runrev.com>
> Sent: Fri, May 10, 2013 1:53 pm
> Subject: Re: Looking for a helper, example, tutorial or something to get
> LiveCode and Spreadsheet data working together
>
>
> 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
>
>
> _______________________________________________
> 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
>