osx - How to manipulate and print a chart in MS Excel from AppleScript? -


In the Apple script, with the current chart in MS Excel for Mac 2008, I am trying to do two things :

  1. Rotate the 3D chart 1 °
  2. Save the chart as an image (PNG)

On me interbits What seems to be, it seems possible but the lack of free cryptography of the script and the absence of non-trivial MS Excel is an example of an example for me on the Web. Gaddafi away.

Just for the savings part, it is so far from me:

  Tell the app "Microsoft Excel" Object Worksheet Activate "iozone-16" Set Object Chase Object 1 Child Object 1 Tell Chat Chat as the Object Object [Picture Type Enumeration] [File Name Unicode Text] # Ar !!! Finally tell  

'1 rotation 1 °' works to include "internal objects" , but it is as long as I have found it. From 'rotate', I mean to rotate the chart object, not the image. Format for this can be done with the Charts dialog box ...

By tinkling this value, this chart changes the object as if under the two images. (15 degrees for effect)

Can make x-axis rotation of chart Can be changed through AppleScript by setting the Property of property property of rotation chart .

The following AppleScript should do the trick:

 Set the image path to  (path on the desktop as text) & amp; Tell the "Chart" Page "Microsoft Excel" keys save the chat chart to the first licking object and save the rotation chart chart as 90 saved image. Type the picture as a PNG file file name IIMPage Tell the end  

Comments