Python: Open Excel Workbook using Win32 COM Api

by

While you found a solution, consider using try/except/finally block. Currently your code will leave the Excel.exe process running in background (check Task Manager if using Windows) even if you close the visible worksheet. As an aside, in Python or any other language like VBA, any external API such as this COM interface should always be released cleanly during application code.

Below solution uses a defined function, openWorkbook() to go two potential routes: 1) first attempts to relaunch specified workbook assuming it is opened and 2) if it is not currently opened launches a new workbook object of that location. The last nested try/except is used in case the Workbooks.Open() method fails such as incorrect file name.

import win32com.client as win32

def openWorkbook(xlapp, xlfile):
    try:        
        xlwb = xlapp.Workbooks(xlfile)            
    except Exception as e:
        try:
            xlwb = xlapp.Workbooks.Open(xlfile)
        except Exception as e:
            print(e)
            xlwb = None                    
    return(xlwb)

try:
    excel = win32.gencache.EnsureDispatch('Excel.Application')
    wb = openWorkbook(excel, 'my_sheet.xlsm')
    ws = wb.Worksheets('blaaaa') 
    excel.Visible = True

except Exception as e:
    print(e)

finally:
    # RELEASES RESOURCES
    ws = None
    wb = None
    excel = None

More Related Contents:

  1. Export Charts from Excel as images using Python
  2. Export a list of stock prices to excel
  3. How to write to an existing excel file without overwriting data (using pandas)?
  4. Writing to an Excel spreadsheet
  5. Convert Excel style date with pandas
  6. How to convert a given ordinal number (from Excel) to a date
  7. Editing workbooks with rich text in openpyxl
  8. Reading Excel File using Python, how do I get the values of a specific column with indicated column name?
  9. append dataframe to excel with pandas
  10. Cannot redirect output when I run Python script on Windows using just script’s name
  11. Windows 7: how to bring a window to the front no matter what other window has focus?
  12. Is there a way to auto-adjust Excel column widths with pandas.ExcelWriter?
  13. .xlsx and xls(Latest Versions) to pdf using python
  14. Convert date from excel in number format to date format python [duplicate]
  15. How to obtain sheet names from XLS files without loading the whole file?
  16. Calling python script from excel/vba
  17. how to write to a new cell in python using openpyxl
  18. Putting many python pandas dataframes to one excel worksheet
  19. Python openpyxl data_only=True returning None
  20. Insert row into Excel spreadsheet using openpyxl in Python
  21. Pandas: Reading Excel with merged cells
  22. openpyxl load_workbook() on a legit .xlsx file leads to a zipfile.BadZipFile error
  23. Can Pandas read and modify a single Excel file worksheet (tab) without modifying the rest of the file?
  24. Get cell color from .xlsx
  25. Detecting Key Presses using win32api in Python
  26. Can I insert matplotlib graphs into Excel programmatically?
  27. Tkinter locks Python when an icon is loaded and tk.mainloop is in a thread
  28. How to return and download Excel file using FastAPI?
  29. Why does SendMessage not work for some applications?
  30. Using openpyxl to read file from memory

Leave a Comment