Extract All Content from an Excel File (including text boxes)

[c.poupin]

Hi

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

is specific to IronPython, swicth the engine to IronPython2 or IronPython3

If you want to use Excel Interrop with PythonNet (CPython3 or PythonNet3), you’ll need to use Reflection or cast COM objects.

Example

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…