Applescript for getting data from a spreadsheet

[Bob Sneidar]

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

Bob


On Dec 9, 2011, at 11:40 AM, zryip theSlug wrote:

> Hi Bob,
> 
> Did you try something like this?
> 
> tell application "Microsoft Excel"
>     set myRange to range "A1:A5" of sheet "mySheet" of workbook "myWorkbook"
>     return value of myRange
> end tell
> 
> This should return a list of values between {} and separated by commas.
> 
> 
> 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