Pull List of COM Add-ins Available in Excel w/ Python Library

Question

I'm trying to build out a process to refresh a series of excel documents on a monthly basis. One part of this process will require refreshing data from an Excel Add-In (In my case this is an add-in called SmartView).

I can't find any info on how to pull a list of add-ins accessible to the pywin32 module. Is there a way to access and iterate through a list of Add-Ins?

Here's what I know works if you know the name of the Add-In:

import win32com.client as win32

xl = win32.gencache.EnsureDispatch('Excel.Application')

helloWorldAddIn = xl.COMAddIns("HelloWorld") # HelloWorld is the name of my AddIn.

Garett · Accepted Answer · 2020-08-24 22:20:50Z

2

The Application.COMAddIns is actually a collection of COMAddIn objects, so you can iterate over the list of available add-ins like:

import win32com.client as win32

xl = win32.gencache.EnsureDispatch('Excel.Application')

for addin in xl.COMAddIns:
    print(addin.description)

answered Aug 24, 2020 at 22:20

Garett

16.9k5 gold badges58 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hofbr Over a year ago

That was it! Thanks Garett

Collectives™ on Stack Overflow

Pull List of COM Add-ins Available in Excel w/ Python Library

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related