Has,
thanks for your reply. I have tried doing what you suggest. the four char
code for the range object is X117, so I did the following:
app('Microsoft
Excel').AS_newreference(aem.app.elements('X117'))['A1'].value()
and this works fine in both Excel 2008 and Excel 2011. My problem is that
this way I can only reference a range in the currently active worksheet.
Using standard appscript syntax I would do the following:
app('Microsoft Excel').worksheets['Sheet1'].ranges['A1'].value()
to access data on a specific cell on a specific worksheet. How do I do that
with the AEM syntax you suggested?
I tried something along the lines of:
ws.AS_newreference(aem.app.elements('X117'))[address]
which won't work since a reference to a worksheet object does not have
the AS_newreference method. Tried playing a bit with AS_aemreference but I
am not getting how this is supposed to work.
Thanks
Christian
> Wild guess: Excel's dictionary defines both a 'ranges' property and a
> 'range' class (plural 'ranges'). AppleScript can just about deal with
> that sort of ambiguity as the compiler can determine from context if a
> 'ranges' keyword is being used as a property name or element name.
> Appscript doesn't have that luxury, so has to favour one
> interpretation or the other; in this case, the former. If you need it
> to go the other way, you'll need to drop down to the aem API
> (equivalent to using chevron syntax in AS); something like:
>
> app('Microsoft
> Excel').AS_newreference(aem.app.elements('xxxx'))['B2'].value()
>
> You'll need to use ASDictionary to export the Excel dictionary as
> plain text in order to look up the correct four-char code to use in
> the aem reference.
>
>
_______________________________________________
Pythonmac-SIG maillist - Pythonmac-SIG@python.org
http://mail.python.org/mailman/listinfo/pythonmac-sig
unsubscribe: http://mail.python.org/mailman/options/Pythonmac-SIG
