Reading directly from Excel

[Phil Davis]

Hi Skip,

The docs are distributed with the product, which you can download and 
look at here:
     http://curryk.com/SpreadlibBeta01.zip

Here is Curry's announcement on the list almost a year ago:
http://lists.runrev.com/pipermail/use-livecode/2012-May/171751.html

HTH -
Phil



On 4/16/13 7:21 PM, Magicgate Software - Skip Kimpel wrote:
> Phil, do you have  a link to the documentation?  I would love to make sure
> that the functions would fit my needs.
>
>
> SKIP
>
>
> On Tue, Apr 16, 2013 at 10:20 PM, Magicgate Software - Skip Kimpel <
> skip at magicgate.com> wrote:
>
>> Oooooo.. thanks for all the good info everybody!  Zryip the Slug, I would
>> be more than honored and elated if you could let me try it out!
>>
>> SKIP
>>
>>
>> On Tue, Apr 16, 2013 at 6:55 PM, Phil Davis <revdev at pdslabs.net> wrote:
>>
>>> 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<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<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<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<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<http://lists.runrev.com/mailman/listinfo/use-livecode>
>>>>
>>>>
>>> --
>>> Phil Davis
>>>
>>>
>>>
>>> ______________________________**_________________
>>> 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<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