Exporting Type Parameters and values to EXCEL

revit
excel
dynamo

#1

Hi GUYS,

I have been trying to create a graph that exporting the Type parameters into Excel so far i haven’t been able to successful.

i want to be able to export the

ADBGROUP : 3
ADBDescription: Computer Monitor etc

ADBCode: COM049


#2

hi there could you upload a picture of wat you have at the moment


#3

This is what i have at the moment and i dont believe its picking up anything


#4

I am trying to achieve this in exel so when the excel spreadsheet is updated i can run a script that would update the information in revit


#5

put Element.ElementType node after all elements of categories that will doe the trick


#6


#7

excellent that’s worked thanks again one more question how can i now separate the parameter and the value in to separate columns ?


#8

you could just do as you where in the first graph u sended


#9

Thanks David,

can i also specify in a list the only 3 parameters i need rather than everything within the whole project


#10

I only need the parameters from List 0 which node would i need to only show this please thanks for the help so far ?


#11

Just make the same graph you had and put element.elementtype node between all elements of categories and the element.getparametervalue node that will work


#12

It doesn’t matter if item 0 is a list or something else (single value)


#14

Are you able to show me an example please.


#15

For S.Rooble.dyn (13.4 KB)
Check this out and let me know if it works


#16

This is perfect thank you David, this has succesfully exported out the values, anyways i could get the headers to appear to to show it coorisponds with the revit headings such as ADBCode, ADBGuide, ADBDescription


#17

Now you can export it to excel and rename it :muscle:


#18

Thank for that I have bee trying to do the reverse and fill in the excel with new data and run it through dynamo with a different script and update the revit values but seems to be an error in the last node any ideas. ???


#19

Maybe your putting to much data in the setparameterbyname node try to make more of those nodes


#20

Hey my scripts seem to be working most of the times however i have a small issue my node is still coming up with an error how can i make it so its grey i am only using it for 1 excel column to be updated within the Revit parameters.