Applescript for getting data from a spreadsheet
bobs at twft.com
Fri Dec 9 16:34:05 EST 2011
Very cool! I guess what I was doing wrong before is that I was not specifying the sheet and workbook name. It kept saying in it's cryptic way that it didn't understand the copy range command. <sigh> Applescript. I love it. I hate it.
On Dec 9, 2011, at 12:54 PM, zryip theSlug wrote:
> 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"
> 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)
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
More information about the Use-livecode