cannot open excel file with pywin32

Question

I want to open an excel file, let it wait for a bit (there is a code that needs to run and returns some data) and then save it to another csv file. I tried to open the excel file first using the pywin32 package but it does not work. The code ran without any issue but Excel just does not open. Here is my code:

import win32com.client as win32

xl = win32.Dispatch('Excel.Application')
wb = xl.Workbooks.Open('C:/Users/123456/OneDrive/PyCharm/my-stdout.csv')

How to get this to open excel, and how to make it wait a bit and then save as another csv file?

Sergio Lucero · Accepted Answer · 2020-05-10 09:50:17Z

0

In Python, waiting is usually accomplished with the use of the sleep function (waiting time in seconds):

import time
do_something()
time.sleep(5)
do_something_else()

For opening up Excel, you should use:

excel = win32.gencache.EnsureDispatch('Excel.Application')

And finally, make sure you use the full path as you are and not just the filename and display the application using:

excel.Visible = True

answered May 10, 2020 at 9:50

Sergio Lucero

9061 gold badge12 silver badges21 bronze badges

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

1 Comment

duckman Over a year ago

it opens excel now, but it opens many files. I used the following codes: xl = win32.gencache.EnsureDispatch('Excel.Application') wb = xl.Workbooks.Open('C:/Users/123456/Documents/test.csv') xl.Visible = True

Collectives™ on Stack Overflow

cannot open excel file with pywin32

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related