Re: excel rows
Re: excel rows
- Subject: Re: excel rows
- From: RJay Hansen <email@hidden>
- Date: Tue, 02 Sep 2014 10:28:33 -0500
Thanks for the help Stan. Turns out I was needing to find offsets from the current row. Got everything working now.
RJay
On Aug 27, 2014, at 5:22 PM, Stan Cleveland <email@hidden> wrote:
> On Aug 27, 2014, at 2:41 PM, RJay Hansen wrote:
>
>> Trying to get some cells from an excel file and put them into an InDesign document. After I get the text from my first cell inserted into InDesign I need to skip down 1000 rows to get my next cell. Apparently I can't just take the current row number and add 1000 to it since the row number isn't actually a number. Can Excel row numbers be coerced into numbers? If so, how? If not, how would you find the next row?
>
> Hi RJay,
>
> The following code is basic, but maybe it will get you pointed in the right direction.
>
> Stan C.
>
> set rowsToGet to {2, 102, 1002}
> repeat with rw in rowsToGet
> tell application "Microsoft Excel"
> ------- get one cell at a time
> set cellContents to formula of cell ("B" & rw) -- raw data
> --> "=SUM(C2:H2)/6"
> set cellContents to value of cell ("B" & rw) -- unformatted value
> --> 12.333333333333
> set cellContents to string value of cell ("B" & rw) -- formatted value
> --> "12.33"
> ------- get a range within one row
> set rangeContents to formula of range ("A" & rw & ":H" & rw) -- raw data
> --> {{"Average", "=SUM(C2:H2)/6", "10", "13", "13", "14", "12", "12"}}
> set rangeContents to value of range ("A" & rw & ":H" & rw) -- unformatted value
> --> {{"Average", 12.333333333333, 10.0, 13.0, 13.0, 14.0, 12.0, 12.0}}
> set rangeContents to string value of range ("A" & rw & ":H" & rw) -- formatted value
> --> {{"Average", "12.33", "10", "13", "13", "14", "12", "12"}}
> end tell
> end repeat
>
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> AppleScript-Users mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
> Archives: http://lists.apple.com/archives/applescript-users
>
> This email sent to email@hidden
_______________________________________________
Do not post admin requests to the list. They will be ignored.
AppleScript-Users mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
Archives: http://lists.apple.com/archives/applescript-users
This email sent to email@hidden