pywin32_excel_com_automation_workbook_cell_quickstart.py

1import win32com.client as win32
2
3def excel_quickstart():
4    # Dispatch the Excel application
5    excel = win32.gencache.EnsureDispatch('Excel.Application')
6    
7    # Make Excel visible
8    excel.Visible = True
9    
10    # Add a new workbook
11    wb = excel.Workbooks.Add()
12    ws = wb.Worksheets("Sheet1")
13    
14    # Write to a cell
15    ws.Cells(1, 1).Value = "Hello from pypiwin32"
16    
17    # Read from the cell to verify
18    print(f"Cell value: {ws.Cells(1, 1).Value}")
19
20if __name__ == "__main__":
21    excel_quickstart()