Reading directly from Excel

[Phil Davis]

Hi Skip,

I added Curry Kenworthy's SpreadLib into one tool for a client and it 
works like a charm. Their spreadsheets are similar but not identical 
formats, but that doesn't stop anything from working. The spreadsheet is 
loaded into a data grid where they can work with it in their LC app's 
environment.

The only SpreadLib link I'm aware of is here:
https://store2.esellerate.net/store/checkout/CustomLayout.aspx?s=STR3897026475&pc=&page=OnePageCatalog.htm

Phil Davis


On 4/16/13 1:26 PM, Magicgate Software - Skip Kimpel wrote:
> Michael... didn't even think to go that route.  These are very consistent
> excel spreadsheets so that might be a solid alternative.
>
> Thanks...
>
> SKIP
>
>
> On Tue, Apr 16, 2013 at 4:06 PM, Michael Grinder
> <michaeltgrinder at gmail.com>wrote:
>
>> Depending on how the data is structured, you may be able to use an ODBC
>> connection to manipulate the Excel file.
>>
>>
>> On Tue, Apr 16, 2013 at 1:26 PM, Magicgate Software - Skip Kimpel <
>> skip at magicgate.com> wrote:
>>
>>> Cut and paste not an option.  I have a client that stores all of their
>> work
>>> in Excel and that will not change.... I need to be able to manipulate
>> that
>>> data on the fly.
>>>
>>> Curry Kenworth, come through for me!  You would be a lifesaver!
>>>
>>> SKIP
>>>
>>>
>>> On Tue, Apr 16, 2013 at 1:30 PM, Colin Holgate <coiin at verizon.net>
>> wrote:
>>>> Doing a copy from the Excel cells and a paste into LiveCode doesn't
>> quite
>>>> work. But, doing a paste into a text editor, and then a paste into
>>>> LiveCode, does work. Or asa worse case you reselect the text after the
>>>> paste in the text editor, and copy that before pasting into 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
>>>>
>>> _______________________________________________
>>> 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
>>
> _______________________________________________
> 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
>

-- 
Phil Davis