The goal is to import an excel sheet to revit using dynamo, but the script won’t read the string. All of the information is correct, but reaches a block once the sheet name is added.
I understand this is a common problem. Does anyone know how to fix this? Or maybe there is a different script needed.
It’s hard to say what’s going on without knowing more information.
What error message is that Data.ImportExcel node showing?
Warning: Data.ImportExcel operation failed.
The error message on List.RestOfItems is ‘Value cannot be null.’
Do you have your Excel opened when running the graph?
I don’t.
Have you tried running this script in Dynamo Sandbox?
Also, maybe the Open XML Excel import node may work here.
It could also be your Excel-installation, have you tried your file on another PC?
I’ll try that in a moment. I’ll let you know if it works.
I wasn’t able to try on a different PC yesterday. The script originally was running in Dynamo Sandbox.
I was able to solve the problem. When you go to import the excel sheet, you need to make sure that you are only importing what you want in Revit. Hiding is not enough. You have to delete extra cells that has information that you don’t want. That was what the hold up was about.
As for the errors, I did a complete restart and was able to refresh the script. I hope this helps anyone who gets a similar problem.
