Re: Reading directly from Excel

2013-04-17 Thread Thomas Fischer
Hi Skip, reading my digests I came across your question (up to the suggestion to use SpreadlibBeta01). If that doesn't work as hoped, did you consider using AppleScript to read the data from the Excel files? You would need a version of Excel, though, but then it works pretty smoothly (I just bu

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
I just wrote a program in VB6 the other day to read an Excel spreadsheet and update a MySql database. It was easy until I needed to "get char 3 of word 5 of line 2 of var" and then I got a headache. I would also LOVE to use LC for these type of things. I thought about exporting to a csv and using L

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