Driving Excel from Python in Windows

by

For controlling Excel, use pywin32, like @igowen suggests.

Note that it is possible to use static dispatch. Use makepy.py from the pywin32 project to create a python module with the python wrappers. Using the generated wrappers simplifies development, since for instance ipython gives you tab completion and help during development.

Static dispatch example:

x:> makepy.py "Microsoft Excel 11.0 Object Library"
...
Generating...
Importing module
x:> ipython

> from win32com.client import Dispatch
> excel = Dispatch("Excel.Application")
> wb = excel.Workbooks.Append()
> range = wb.Sheets[0].Range("A1")
> range.[Press Tab]
range.Activate                 range.Merge
range.AddComment               range.NavigateArrow
range.AdvancedFilter           range.NoteText
...
range.GetOffset                range.__repr__
range.GetResize                range.__setattr__
range.GetValue                 range.__str__
range.Get_Default              range.__unicode__
range.GoalSeek                 range._get_good_object_
range.Group                    range._get_good_single_object_
range.Insert                   range._oleobj_
range.InsertIndent             range._prop_map_get_
range.Item                     range._prop_map_put_
range.Justify                  range.coclass_clsid
range.ListNames                range.__class__
> range.Value = 32
...

Documentation links:

More Related Contents:

  1. How to execute Python scripts in Windows?
  2. Python convert csv to xlsx
  3. Pandas cannot open an Excel (.xlsx) file
  4. check if a file is open in Python
  5. Get name of current script in Python
  6. How can I open an Excel file in Python?
  7. Could pandas use column as index?
  8. ImportError: No module named win32com.client
  9. How to convert a python datetime.datetime to excel serial date number
  10. xls to csv converter
  11. How to concatenate three excels files xlsx using python?
  12. Get formula from Excel cell with python xlrd
  13. Error: Unsupported format, or corrupt file: Expected BOF record
  14. Refresh Excel External Data with Python
  15. Print chosen worksheets in excel files to pdf in python
  16. How to find the last row in a column using openpyxl normal workbook?
  17. Write pandas dataframe to xlsm file (Excel with Macros enabled)
  18. From password-protected Excel file to pandas DataFrame
  19. Leave dates as strings using read_excel function from pandas in python
  20. IndexError: too many indices for array
  21. Adjust cell width in Excel
  22. Get Excel-Style Column Names from Column Number
  23. Edit existing excel workbooks and sheets with xlrd and xlwt
  24. Purpose of #!/usr/bin/python3 shebang
  25. Checking if a website is up via Python
  26. Pandas: parse merged header columns from Excel
  27. django excel xlwt
  28. Openpyxl max_row and max_column wrongly reports a larger figure
  29. Excel, How to split cells by comma delimiter into new cells
  30. Setting styles in Openpyxl

Leave a Comment