'Python - Control/Edit existing window/workbook of Excel

I'm working on a little script to automate some data entry. I have two windows open that this same data needs to be entered in every 15 minutes or so. One program I have it entering through GUI manipulation with pywinauto. The other window is an Excel workbook.

My problem is, the workbook is and must be left open (it displays a chart I use and analyze in real-time). I'm wondering how I can go about having my Python script find that specific window (the file name and location is known) without having to open a new instance. I need to edit 4 cells on a specific Worksheet on this Workbook.

Is this possible (to edit/control an existing Workbook that is already open in Windows)?

Solution 1:^[1]

Yes, it's possible. You can use Workbooks property of Excel.Application object:

import win32com.client
excel = win32com.client.Dispatch('Excel.Application')
for w in excel.Workbooks:
    print(w.Name)

You should see "Book1" printed, the name of the new file open. Then run this command:

excel.Workbooks[1].Worksheets[1].Cells[1][1].Value = '444'

You should now see cell A1 have the value of 444.

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution	Source
Solution 1	johnml1135

'Python - Control/Edit existing window/workbook of Excel

Solution 1:[1]

Sources

Related Questions

Solution 1:^[1]