Excell export multiple schedules

Hi guys,
I have got an amazing script developed by Aussie BIM Guru this is it from this YT clip…

A lot of credit to Gavin who is an author of this script it is really powerful. I use it a lot and it works well in Revit og dynamo ver. 2024.
Problem came with last release of Revit 2025 and i presume some of update in Dynamo it self.
Script which export only one schedule function still ok but the ver. which export multiple schedules does not ;(
Somebody had same chelenges like me or i do something wrong.

Will try to set as an attachment of this script to check by sombody more expirenced in Dynamo than me :wink:

Regards!
Shemek!

Here is the script in Dynamo ver. just have a look.
Like i said it works in Revit 2024 but does not want in 2025…
Excell_Export_Multiple.dyn (53.1 KB)

What is the warning message you get?
Which Python engine are you using, and do you have a compatible version thereof?

Acctually i do not have any warning message.
It looks like script works well. But when the running of the script is done
i do not have a message that it completed with success like i do have that message in 2024
Below script result for 2025:


And the same result for 2024:

When i am in the dynamo environment it looks same…
no warning…


and after all have an message that run i completed…

Run is completed but in result excell file is totaly empty and nothing is in it ;(

I use CPython3 and IronPython2

I navigate the problem. I talked with technical support in my company and they said that there were a several significant changes in API in 2025 ver av revit. Problem lies in here accutualy, see below:


And like following comment below says:

Now I know that i do not make a mistake it is related with something completely different. For update need to wait. Finger crossed that it wil be fixed up quite soon :slight_smile:

Case closed…

Hi, I have the same problem, so the conclusion is that it cannot be used in Revit 2025?

At this point unless bumblebees date updates in package manager, assume it will not support 2025 due to com APi changes in net core.

Im not familiar of a package/node that supports such specific writing to worksheets currently, i believe most have had to use python at the least for now. It’s possible in c# and netcore8 using nuget (not dynamo) packages like closedxml in my experience, but bumblebee is written in ironpython2 so will not support com api which it depends on in 2025+.

Example code for anyone taking the plunge:

you can use directly the OOTB node Data.OpenXMLExportExcel, it works with multiple sheets / datas at input

2 Likes

Thanks! Didn’t know it could do multiworksheet for one file path, nice one.

1 Like