How to use Python's win32com to "save as" an Excel file?

Question

I have a small Python code to open an Excel file. Now I want to "Save As" with a different name but same format. How do I do that?

Tomerikoo · Accepted Answer · 2022-07-07 10:15:51Z

2

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()

edited Jul 7, 2022 at 10:15

Tomerikoo

19.6k16 gold badges57 silver badges68 bronze badges

answered Jan 10, 2021 at 21:07

EkaterinaSS

213 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Raf Over a year ago

Note that office.Quit() will close all excel instances you have open.

Collectives™ on Stack Overflow

How to use Python's win32com to "save as" an Excel file?

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related