Python's win32com not closing?

Question

I'm trying to close an Excel sheet that I have open using win32com, but the following code doesn't work:

from win32com import DispatchEx
xlApp = client.DispatchEx("Excel.Application")
books = xlApp.Workbooks.Open(str(main_folder) + "\\Original.xlsm")
ws = books.Worksheets["Sheet 1"]
ws.Visible = 1
ws.ExportAsFixedFormat(0, str(main_folder) + "\\Duplicated")
ws.Close()

I get the following error:

"AttributeError: .Close"

How should I solve this?

Worksheet doesn't have a close method. learn.microsoft.com/en-us/office/vba/api/excel.worksheet — tdelaney
– tdelaney, Commented Feb 20, 2020 at 18:30

ndclt · Accepted Answer · 2020-02-20 18:48:41Z

1

If you want to close the workook, you can do:

from win32com import DispatchEx
xlApp = client.DispatchEx("Excel.Application")
books = xlApp.Workbooks.Open(str(main_folder) + "\\Original.xlsm")
ws = books.Worksheets["Sheet 1"]
ws.Visible = 1
ws.ExportAsFixedFormat(0, str(main_folder) + "\\Duplicated")
books.Close()  # changed line, use books instead of ws.

You can also see xlwings if you have lots of things to do with Excel.

answered Feb 20, 2020 at 18:48

ndclt

3,2232 gold badges16 silver badges31 bronze badges

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

Comments

pjain · Accepted Answer · 2020-12-14 18:24:14Z

-1

Please use the below command to close the excel application.

xlApp.Quit()

answered Dec 14, 2020 at 18:24

pjain

11 bronze badge

Collectives™ on Stack Overflow

Python's win32com not closing?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related