i get a warning and it does not export a spread sheet. does anyone recognize athis error?
Any chance the file is locked, opened by someone else or another application, or in a location you don’t have write access to?
no same issue if i run this into my documents folder
Missing inputs on the alternative node.
originally ran this in r2025 and i just tried this in r2023 and it works.
should clarify why isn’t this working in r25?
Can’t see with what you have shown. Is there null data or an inconsistent structure in the data being written in 2025? Check with a List.Flatten node to remove all the data structure followed by an Object.Type to find out what types of data you have and a List.UniqueItems node to find out what you are working with.
i dont think its the data coming in as it works in r23. i cant flatten this one its a list of sheet name number and view name.
I’m having the same issue in one of my other scripts too…this one uses flatten.
The data or structure thereof needs to be reviewed.
Pull the object type after the flatten with an Object.Type node. Then a List.UniqueItems node to find out if all values are strings or numbers, or if something is a a null or element or something else which cannot be pushed to excel.
1 Like
I think the ‘data’ input is bad - a 1D list.
Try promoting it to a list of lists as this is the preferred data structure to/from Excel.
Make sure the file path exists and is just one file path. If you are trying to write multiple sheets or files then that may require list levels.
path is correct, and the data is a list of lists of strings.
seems like i got this other node to work. so, what changed in Revit r25 to make the prior node to not work? because I have script that pulls the data back in and the import is doing the same thing. both import nodes give me that errors. and again this works in r23 and r24 but not in r25
So, I tried this on another machine and it’s the same deal. How can I check what version of openXML?
per another topic, jacob.small commented to use CSV file instead of excel. This worked, I did have to transpose the list for the CSV node.