Revit 2025 & Dynamo - set and get values via Excel


use Data.ExpoortToExcel → everthing works well
use Element.Set.ParameterByName for “Window Wallaxis Position” with new value 60. No error message after exe, but the value is not changed? please see attached file Screenshot 2025-07-28 113423|690x398

when I run Data.ExpoortToExcel again the values in Excel are changed!! but not in Revit visible??? Family only shows 50 for “Window Wallaxis Position” ???

If you want I can share the Dynamo-Script and Excel file.

BR

If youre not doing get and set values to/from excel id suggest doing that. You might be writing back to your excel before reading it if doing it in one script, which would explain the behavior your describing.

1 Like

There are two Dynamo files that must be executed manually one after the other.

  1. Run 01 Economy 50 door create Excel from Revit 2025.dyn
  2. Open, correct, and save the Excel file.
  3. Run 02 Economy 50 door write Parameter form Excel to Revit 2025
  4. Check the Revit file.
    01 Economy 50 door create Excel from Revit 2025.dyn (366.4 KB)
    02 Economy 50 door write Parameter form Excel to Revit 2025.dyn (38.4 KB)
    Economy 50 door 2025.xlsx (18.5 KB)

It looks like you’re relying on some fairly manual data isolation strategies there, so I’ve built an example of how you can more scaleably manage this (just with text parameters in this example). From what I can tell you’re mixing/matching instance and type values which has the tendency to get confusing as well.

See below example of how I’d go about a toolkit like this. It’s intended to be ran via Dynamo player (doesn’t suit multiple runs in dynamo itself). Uses Crumple package.

Export Revit data_R23.dyn (48.8 KB)
ExportData.xlsx (9.2 KB)
Import Revit data_R23.dyn (25.3 KB)
Sample_R23.rvt (2.2 MB)

1 Like

Hi Gavin, thanks a lot. Come back to you next week. Now out of office. BR Roger

1 Like

perfect

1 Like

just sayin… i always enjoy watching and learning from the clear logic paths of your script. bravo!

2 Likes