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

dunbarx at aol.com dunbarx at aol.com
Fri May 10 13:03:33 CDT 2013


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

 


More information about the use-livecode mailing list