pywin32_excel_com_automation_workbook_creation_demo.py

1import win32com.client as win32
2
3def excel_demo():
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    # Set a cell value
15    ws.Cells(1, 1).Value = "Hello from pywin32"
16    
17    # Range operations
18    ws.Range("A2:B2").Value = [["Column A", "Column B"]]
19    
20    print(f"Excel version: {excel.Version}")
21
22if __name__ == "__main__":
23    excel_demo()