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
