How to use Python's win32com to "save as" an Excel file?
I have a small Python code to open an Excel file. Now I want to "Save As" with a different name but 开发者_StackOverflowsame format. How do I do that?
Just use the SaveAs
method:
import win32com.client
office = win32com.client.Dispatch("Excel.Application")
wb = office.Workbooks.Open("C:/FileName.xlsx")
wb.SaveAs(Filename="C:\\NewFileName.xlsx")
wb.Close()
office.Quit()
精彩评论