Re: Reading directly from Excel

2013-04-17 Thread Thomas Fischer
just built a small AppleScript App to read data from Excel files). Best Thomas Am 16.04.2013 um 19:00 schrieb use-livecode-requ...@lists.runrev.com: > Date: Tue, 16 Apr 2013 12:32:59 -0400 > From: Magicgate Software - Skip Kimpel > To: How to use LiveCode > Subject: Reading di

Re: Reading directly from Excel (Current SpreadLib Version)

2013-04-17 Thread Curry Kenworthy
Howdy friends, I was away from the list in honor of Uncle Sam Week; thanks for posting the SpreadLib download info! For more features, here is the latest version of SpreadLib, 0.2.001: http://curryk.com/Spreadlib02001.zip SpreadLib can import a sheet as tabbed text or array, and the array

Re: Reading directly from Excel

2013-04-17 Thread 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

Re: Reading directly from Excel

2013-04-16 Thread 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 < s...@magicgate.com> wrote: > Oo.. thanks for all the good info everybody! Zryip the Slug, I would > b

Re: Reading directly from Excel

2013-04-16 Thread Magicgate Software - Skip Kimpel
Oo.. 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 wrote: > Hi Skip, > > I added Curry Kenworthy's SpreadLib into one tool for a client and it > works like a

Re: Reading directly from Excel

2013-04-16 Thread 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 en

RE: Reading directly from Excel

2013-04-16 Thread Terry Dennis
Date: Tue, 16 Apr 2013 13:25:09 -0400 From: "Ralph DiMola" To: "'How to use LiveCode'" Subject: RE: Reading directly from Excel Message-ID: <002a01ce3ac7$5856ceb0$09046c10$@net> A couple of years ago, I built a prototype LC application to directly a

Re: Reading directly from Excel

2013-04-16 Thread Magicgate Software - Skip Kimpel
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 wrote: > Depending on how the data is structured, you may be able to use an ODBC > connection to ma

Re: Reading directly from Excel

2013-04-16 Thread Michael Grinder
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 < s...@magicgate.com> wrote: > Cut and paste not an option. I have a client that stores all of their work > in Excel

Re: Reading directly from Excel

2013-04-16 Thread Richmond
On 04/16/2013 10:26 PM, Magicgate Software - Skip Kimpel 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!

Re: Reading directly from Excel

2013-04-16 Thread Magicgate Software - Skip Kimpel
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 wrote: >

Re: Reading directly from Excel

2013-04-16 Thread Colin Holgate
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. __

RE: Reading directly from Excel

2013-04-16 Thread Ralph DiMola
ecode-boun...@lists.runrev.com] On Behalf Of Magicgate Software - Skip Kimpel Sent: Tuesday, April 16, 2013 12:33 PM To: How to use LiveCode Subject: Reading directly from Excel Is there any way to read in cells directly from an Excel spreadsheet (not CSV)? Would make my life on my current project a lot e

Re: Reading directly from Excel

2013-04-16 Thread Andrew Kluthe
Curry Kenworth has been working on a library for that for some time. SpreadLib handles importing, SpreadOut handles exporting. I contacted him off list about it a while back and March 26th he said: "SpreadLib and SpreadOut currently have funding for the basic features and just need a little more

Reading directly from Excel

2013-04-16 Thread Magicgate Software - Skip Kimpel
Is there any way to read in cells directly from an Excel spreadsheet (not CSV)? Would make my life on my current project a lot easier if I could! If not, I guess I could always write a command line script that would covert it over to CSV before manipulating it in LC. Just thought I would ask bef