CODEWITHSUNDEEP
excelxlwings
Valendar Turner
Valendar Turner

Reputation: 63

xlwings wipes out my EXCEL addin

I own a professional Addin for EXCEL called Valuesoft. It performs several calculations related to equity (stockmarket) data. It is a 160K dll file and works fine from EXCEL including from VBA scripts. However, as soon as an EXCEL file (Workbook) is opened using xlwings from Python the dll disappears (along with the Addins tag on the EXCEL menu).

Upvotes: 1

Views: 2132

Answers (1)

Felix Zumstein
Felix Zumstein

Reputation: 7070

This question or this msdn article seem to explain what's happening and give you a workaround.

Since you are using an xll add-in, adopting msdn's code sample to xlwings should look something like that:

import xlwings as xw
wb = xw.Book('YourWorkbook.xls')
wb.app.api.RegisterXLL(r"C:\path\to\YourAddIn.xll")

Upvotes: 1

Related Questions