On Fri, Dec 9, 2011 at 9:06 PM, Bob Sneidar <b...@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@lists.runrev.com
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-livecode
