At most one email a week. Unfollow anytime with one click.
Transcript
The full narration of this video. The current sentence is highlighted while the video plays; click any sentence to jump there.
Show transcript
Introduction
In this video, the observation data from Excel automatically enters Revit, and 12 windows are colored according to their condition. Let's get started. Use a project copy. Hello! In this video, we connect Excel with Revit using Dynamo. The observation data from Excel will enter the window parameters, and then the windows are colored according to their condition. Use a project copy. Open Dynamo from the Manage tab in Revit, then click Launch Dynamo.
Step 1: Open Dynamo from the Manage tab in Revit
Wait until the windows open.
Step 2: Create a new workspace with the New button
On the initial page, click New to create an empty workspace.
Step 3: Select all project windows
First, select all windows in the project. Add the Categories node and select Windows, then the All Elements of Category node.
Step 4: Read the Excel file with OpenXMLImportExcel
Now we read the Excel file. In one code block, write four texts: the Excel file location, the sheet name, the parameter name Mark, and the parameter name Comments. Then add the OpenXML Import Excel node and connect the file location and sheet name.
Step 4: Read the Excel file with Pas
Watch displays the Excel content, the first row is the column header, and the rest are data for each component.
Step 5: Read the Mark for each window
Next, read the Mark number for each window. Add the .getParameterValueByName element, then connect all windows and the Mark parameter name.
Step 6: Match component names with Dictionary
This is the most important part: matching the Excel data with the windows. In the code block, list.restOfItems removes the header row, list.transpose separates the columns, then Dictionary.byKeysValues creates a dictionary, with the component name as the key and the condition as the value. Dictionary.valueAtKey searches for the condition of each window based on its Mark, even if the order in Excel is different. Watch displays the condition of the 12 windows.
Step 7: Write the observation results to the Comments parameter
Write the result to Revit using the .setParameterByName element. Connect the windows, the Comments parameter name, and the condition from the matching result.
Step 8: Color the windows according to their condition
To make it easier to see, we color the windows according to their condition. In the code block, we create three colors: green for good, orange for cracked, and red for damaged. Then a dictionary that matches the condition with its color. Connect to the element .overID ColorInView.
Step 9: Check the results in Revit - Na Colors
We check in Revit using the ConsistentColors mode. Good windows are green, cracked ones are orange, and damaged ones are red.
Done! The Excel observation data is now in Revit
Done. The observation data in Excel now appears directly in the Revit model. Change the Excel content, run it again, and the results will change accordingly. Goodbye! Want to master Dynamo and Revit? Cerdas Inovasi Digital offers courses on Revit and Dynamo, BIM modeling services and Dynamo script creation, as well as selling project files and Dynamo scripts from this tutorial series. Contact us via WhatsApp, or visit cerdasinovasidigital.com Goodbye in the next episode! Thank you for watching! Thank you for watching!
Ask the class material
Type a question or keyword; we find the part of this episode that explains it and jump the video there.
My notes
Notes are saved with the current video time and are only visible to you.
Questions & answers
Stuck on a step? Ask here; the instructor and other learners can answer.
No questions yet.
Your instructor
Cerdas Inovasi Digital Team
Software developers, BIM & 3D engineers, and AI practitioners
52 video classes1,276 episodes
We build software, BIM models, games and AI automations for clients every day, and turn that hands-on work into step-by-step classes: every step is shown on screen and comes with a PDF guide you can keep.
