Reading directly from Excel

[Magicgate Software - Skip Kimpel]

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