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
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
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
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
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
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
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
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
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
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!
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:
>
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.
__
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
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
14 matches
Mail list logo