Applescript for getting data from a spreadsheet

zryip theSlug 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"
	activate
	COPY RANGE range "A:D" of sheet "mySheet" of workbook "myWorkBook"
end tell

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
- Window
- Workbook
- Sheet
- Range
- Chart
- Shape
- Printing

The library will come for mac and windows.


Best regards,
-- 
-Zryip TheSlug- wish you the best! 8)
http://www.aslugontheroad.com



More information about the use-livecode mailing list