Excel.Worksheets node cannot read from Excel sheet

Revit
, ,
1

I am trying to read the worksheets from an excel file using the node Excel. Worksheets from data-shapes but it keeps reporting a null and subsequently causing the error on the List.GetItemAtIndex. I am using Revit 2025.4.1 with DynC 3.3.x

I am pretty sure that working in Revit 2022, 2023 but not in 2025 for some reason. I am not a programmer so I am sorry if the answer is easy and its just me not seeing it. I searched the forum and did read about archilab causing issue and I installed that package yet still the data shape node wont read the worksheet regardless of the excel format used

Any help or workaround would be much appreciated

image
image1072×630 152 KB

image
image1920×1212 154 KB

2

…I am not a programmer…

pandas or openpyxl to the rescue but they both need u to put in a bit of coding effort. i hope to see some node-only workaround.

edit: python - getting sheet names from openpyxl - Stack Overflow

good reference for openpyxl imports
Excel tabs count - Dynamo

2 Likes
3

It is likely that you don’t have the right version of IronPython2 for your Dynamo environment. Note that IronPython2 is unsupported and as such you are adding known security vulnerabilities into your environment by continuing to use IronPython2, and that eventually it won’t be able to be made to work at all.

I recommend that you a tandardize your sheet names within the workflow so you don’t have to look them up after the first run.

1 Like
4

Thanks for the reply Jacob. I will try to standarize the sheet names and incorporate them into the workflow but out of curiosity where can I check which ironpython2 version is the compatible one. I am using Dynamo Revit 3.3.x on Revit 2025…The one intalled is ironpython 3.2 and Archilabs 2025.300.1125 and also tried the .1225

5

Thank BIMAmbi; I will try to tinker around with see if I can get something to work. What can happen? nothing worse than what I got now, right? :smiley:

1 Like
6

In addition to @BimAmbit post, you also can use OpenXml SDK in a python node

for information, the switch to Net 8+ (.Net Core) means that we can no longer use directly assemblies in the windows MAC (like Excel Interop), do some packages must be to update

2 Likes
7

Think you need a IronPython2 version not 3. Read the package description for compatibility.

8

I meant IronPython2.7 version 3.2… but i did test them all none seem to work

image
image1088×251 62.2 KB

1 Like
9

Then it is likely that the Datashapes code needs to be updated as @c.poupin noted above.

1 Like