ExcelInterop vs OpenXML in CPython3

[c.poupin]

Hi,
you can use Excel Interrop with CPython3/PythonNet but need to cast each object to the correct Interface

a small example here

Get Excel sheets names

Hello, using COM objects is more difficult with PythonNet, here some solutions [image] without Excel Interrop using OpenXml (Dynamo has integrated this lib since 2.10, need to be confirm) import sys import clr import System from System import Array from System.Collections.Generic import List, IList, Dictionary clr.AddReference('DocumentFormat.OpenXml') import DocumentFormat from DocumentFormat.OpenXml import * from DocumentFormat.OpenXml.Packaging import * from DocumentFormat.OpenXml.Spre…

for OpenXML, you can find many examples in GitHub in C# (but the portage to Python is not simple)

https://github.com/search?l=C%23&q=OpenXml+CellReference&type=Code

@Ben_Osborne1

I am frankly not wanting to go the route of using any non-built in 3rd party libraries

I understand the argument, but if you can, take a look at the Python libraries pandas and openpyxl

you can also install the IronPython package