CODEWITHSUNDEEP
pythonexceladd-inoffice-addinsexcel-addins
Atit Bimali
Atit Bimali

Reputation: 73

Excel add-ins in Python

Is there any way I can make Excel add-ins/extensions using Python?

I have tried javascript but haven't found any result about making add-ins on python.

Upvotes: 3

Views: 5108

Answers (2)

stevecu
stevecu

Reputation: 506

You could try xlOil (disclaimer: I wrote it). The docs are here. To write a simple three input function, you would install xlOil using:

pip install xloil
xloil install

Then write:

import xloil

@xloil.func
def myfunc(x, y, z):
    return x + y * z

Put this code either:

  1. In a py file in the same directory as your spreadsheet, named Book1.py (if your sheet is called Book1.xlsx)
  2. In a py file on your python module path, then edit %APPDATA%\xlOil\xlOil.ini to load it as described in the docs.

Start Excel, open your spreadsheet and the function will be available as myfunc.

Upvotes: 5

Eugene Astafiev
Eugene Astafiev

Reputation: 49397

VSTO (or OfficeJS) doesn't provide anything for Python. There is no framework for Python developed by MS.

You may find custom extensions like PyXLL helpful.

Upvotes: 0

Related Questions