Applescript for getting data from a spreadsheet
zryip.theslug at gmail.com
Fri Dec 9 14:54:47 CST 2011
On Fri, Dec 9, 2011 at 9:06 PM, Bob Sneidar <bobs at twft.com> wrote:
> Thanks man! Can I come sit at you feet and learn of your greatness?? ;-) Seems though that Excel locked up. It works for small selections, but Excel didn't like it when I did that for 4 columns of 4000+ rows. Also, I wonder if referencing entire columns might try to get all the data in all the *possible* rows instead of all the rows that have data in them? That is why I was trying to get Excel to actually SELECT the columns and then copy them to the clipboard.
> Maybe I should move my Excel data to a Livecode stack. Hmmm...
No need to select the columns, you can copy them directly in the clipboard.
An example for copying columns A to D:
tell application "Microsoft Excel"
COPY RANGE range "A:D" of sheet "mySheet" of workbook "myWorkBook"
Note that the command is named COPY RANGE, so don't forget to repeat
the word "Range" two times.
Maybe you will be happy to know, I'm actually working on an Excel
Library for Livecode.
The library will covered the following topics:
- Excel Application
The library will come for mac and windows.
-Zryip TheSlug- wish you the best! 8)
More information about the use-livecode