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 <and...@ctech.me> To: How to use LiveCode <use-livecode@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.rauter...@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.rauter...@gmail.com > _______________________________________________ > use-livecode mailing list > use-livecode@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 and...@ctech.me _______________________________________________ use-livecode mailing list use-livecode@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@lists.runrev.com Please visit this url to subscribe, unsubscribe and manage your subscription preferences: http://lists.runrev.com/mailman/listinfo/use-livecode
