Accessing XLSX files from pyrevit

Runtime
2

I do not think openpyxl is included with embedded cpython.

An alternative to deal with excel files in ironpython is to use:

import clr
clr.AddReferenceByName('Microsoft.Office.Interop.Excel, Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c')
from Microsoft.Office.Interop import Excel

Konrad Sobon and David Mans built this library that I use:

2 Likes