Ok. I figured the CSV part out, but paths for saving in appscript are
kicking my butt.
If anyone has any suggestions I'd appreciate them.
Thanks,
Dan
On Fri, 18 Mar 2011 12:00:02 +0100,
pythonmac-sig-requ...@python.org wrote:
Hi there-
I have the
following AppleScript:
set theOutputPath to (path to desktop folder as
string) & "My Saved Workbook.csv"
tell application "Microsoft Excel"
tell active workbook
save workbook as filename theOutputPath file
format CSV file format
end tell
end tell
This works fine. When I try
to use appscript I cannot get the stinking spreadsheet to save as a CSV
file with the following:
from appscript import *
excel =
app('/Applications/Microsoft Office 2008/Microsoft
Excel')
excel.open('/Users/danr/Desktop/Test.xlsx')
name =
excel.worksheets[1].name.get()
print(name)
excel.worksheets[1].save_as(filename
= 'boogers.csv', file_format = "CSV")
Any pointers?
Thanks,
Dan _______________________________________________
Pythonmac-SIG maillist - Pythonmac-SIG@python.org
http://mail.python.org/mailman/listinfo/pythonmac-sig
unsubscribe: http://mail.python.org/mailman/options/Pythonmac-SIG
