Applescript for getting data from a spreadsheet

Bob Sneidar 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. 

Bob


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"
> 	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
> 
> _______________________________________________
> use-livecode mailing list
> use-livecode at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-livecode





More information about the Use-livecode mailing list