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

Posted by Stu Thompson on Stack Overflow See other posts from Stack Overflow or by Stu Thompson
Published on 2010-05-16T14:00:45Z Indexed on 2010/05/16 14:10 UTC
Read the original article Hit count: 427

Filed under:

applescript

|

excel

|

osx

With an existing chart in a MS Excel for Mac 2008, in AppleScript, I am trying to do two things:

Rotate a 3D chart 1°
Save the chart as a image (png)

From what I've found on the Intertubes, it seems possible. But AppleScript's awkward verbosity and the lack of non-trivial MS Excel AppleScript examples on the web are too much for me to overcome.

Just for the saving part, this is what I have so far:

tell application "Microsoft Excel"
    activate object worksheet "iozone-16"
    set cht to chart object 1 of active sheet
    tell cht
        #save as chart object [picture type enumeration] [file name Unicode text]
        #Argh!!! 
    end tell
end tell

The 'rotate 1°' task seems to involve "internal objects", but that is as far as I've gotten.

© Stack Overflow or respective owner

Related posts about applescript

Import AppleScript methods in another AppleScript?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is there a way to use defined AppleScript methods in other AppleScripts which reference the original AppleScript with something similar to import (f.e. in PHP)? I wrote a methode to set Skype status and mood-text: on setSkypeStatus(status, mood_text) tell application "System Events" … >>> More
Open an application with AppleScript in an exact space

as seen on Super User - Search for 'Super User'
Is it possible to open an application with AppleScript in an exact space? >>> More
Applescript file dialog with UI scripting

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to open a file in a not so scriptable area of an application. I got halfway there by using UI scripting to select the proper menu item, but this opens a standard file dialog. How can I set the destination of the file dialog with Applescript? >>> More
Applescript studio - how do I get every control in a window

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm trying to enable or disable all the control in a window as the programme changes from interactive to non-interactive mode. How can I ask a window to give me all its contents? every control of window "mainWindow" doesn't work, nor does contents of window "mainWindow" Actually, I haven't been… >>> More
How do i add applescript support to my Cocoa app

as seen on Stack Overflow - Search for 'Stack Overflow'
i am new to the world of cocoa programming, i want to add applescript support to my app. Also the example at apple's website seems out of date >>> More

Related posts about excel

Excel error "This workbook contains Excel 4.0 macros or Excel 5.0 modules"

as seen on Super User - Search for 'Super User'
I have a workbook that was protected via the Protect Workbook feature. It was sent to someone else to modify. When they sent it back, it was unprotected and when I try to reprotect it I get this error, "This workbook contains Excel 4.0 macros or Excel 5.0 modules. If you would like to… >>> More
Open excel 2007 excel files and save as 97-2003 formats in VBA

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a weird situation where I have a set of excel files, all having the extension .xls., in a directory where I can open all of them just fine in Excel 2007. The odd thing is that I cannot open them in Excel 2003, on the same machine, without opening the file first in 2007 and going and saving… >>> More
Creating Excel or Excel compatible Spreadsheets on the server side in C#

as seen on Stack Overflow - Search for 'Stack Overflow'
I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed… >>> More
vba access values from excel workbook from another excel workbook

as seen on Stack Overflow - Search for 'Stack Overflow'
Any ideas why this code will not work? Workbooks.Open Filename:="C:\a.xls" Workbooks("a.xls").Activate Worksheets("b").Select Dim OutputArray(10, 10) OutputArray(1, 1) = Workbooks("c.xls").Worksheets("worksheet_otherthan_default").Select.Range(A1).Value I'm trying to run a macro in one file (unnamed… >>> More
Excel workbook event order and usage when closing Excel

as seen on Stack Overflow - Search for 'Stack Overflow'
Given the following workbook events: BeforeClose BeforeSave Please tell me: - The firing order in the case of multiple workbooks alreay opened (wb1, wb2 and wb3 are opened in this order) and the user closes Excel. You can assume all 3 needs saving. - What happen if user cancels one of the saving… >>> More