Re: Contents of an Excel cell
Re: Contents of an Excel cell
- Subject: Re: Contents of an Excel cell
- From: "Kabbes, Dan-DLI" <email@hidden>
- Date: Wed, 17 Apr 2002 17:54:50 -0500
This will work in an Excel tell block with a cell selected. I have only used
it for numbers, so I don't know what it would do if the cell value has text.
I am using ver 98.
set curCell to the Selection
set theContents to the Value of Cell curCell
I have also used something like:
set custAddress to text of Cell addressCell
when I am moving text from Excel into another application.
Hope that helps.
Dan
--
>
From: Christopher Coulon <email@hidden>
>
Date: Wed, 17 Apr 2002 09:25:29 -0700
>
To: AppleScript List users <email@hidden>
>
Subject: Contents of an Excel cell
>
>
I am scripting an Excel worksheet and need to test the contents of a cell to
>
stop a repeat loop, but I can't seem to find the AS expression to get the
>
contents of an given cell. Is there a line that will return the value of
>
"R3:C3" so that I can tell if its numeric value is greater than zero?
>
>
set myCell to contents of "R3:C3"
>
>
or
>
>
set myCell to value of "R3:C3"
>
>
don't work.
>
>
Thanks in advance.
>
>
Chris
>
>
***************************************
>
The GAIA Group
>
Global Automated Image Analysis
>
>
We welcome image analysis problems in all fields.
>
www.theGAIAgroup.org
>
Christopher Coulon, Ph.D., Founder
>
email@hidden
>
***************************************
_______________________________________________
applescript-users mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/applescript-users
Do not post admin requests to the list. They will be ignored.