Reading directly from Excel

[Magicgate Software - Skip Kimpel]

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>
>>
>
>