The task is simple. I just want to import data from my excel sheet into my Sheet schedule so that I don’t have to manually write in every drawing from my consultant (they don’t use Revit). I am new to dynamo and have been using Revit for 6 months now. I have my excel sheet formatted I think, but when I try to use the excel import node in dynamo I always get an error. I have attached my starting code.
I would really like to learn this software for automation purposes, but to be frank, there are basically no relevant tutorials specifically for this task as they are all outdated due to Dynamo’s new Excel nodes
To get started you most likely need to close the Excel file as stated in the error message.
I also think you need an integer not a number for start row/column
Most workflows rarely change in terms of basic logic and requirements. The new excel nodes work pretty much the same as the old ones and the rest of the workflow should still be valid. There are a ton of threads dealing with reading excel data and writing it back to Revit. Don’t get disheartened if those other threads deal with different elements or different data, the processes remain essentially the same. You can use those conversations and solutions to find a starting point and start working out your specific requirements.
Thanks for the encouragement! But I suppose then I still have the issue of the fact that there is still some error. Closing the Excel file did not seem to help much. Even without a number node, or a “sheet name” node (i.e. exclusively the file path node, the file to path node, and the excel import node), I still get an error.
Sometimes your excel file will just get locked if you try to do too much with it while it’s already in use. If you haven’t rebooted your computer since you last tried, do that first, then try running your graph again with no excel applications open. You do need to have inputs for at least filePath and sheetName as those are required.
