Hello, I’m new to Dynamo and I would really appreciate if somebody can help me with what I am trying to do. I am trying to export to Excel data from Mechanical Equipment (A - Mech Equip to Excel Graph.png), but I am getting different or missing data on the resulting Excel file (B - Mech Equip Excel Table.png) than the data the Mechanical Equipment shows in Revit (C - Mech Equip Revit Schedule.png). Please see the images attached [A%20-%20Mech%20Equip%20to%20Excel%20Graph] I am not sure what I am doing wrong. I hope somebody can help me to understand why this is happening. Thank you in advance. All the best

Hello Again, I am sorry for this auto-reply, but I got an error when trying to add the other two images that explain my problem and I decided to try to add them this way. I hope is ok. [B%20-%20Mech%20Equip%20Excel%20Table]

[C%20-%20Mech%20Equip%20Revit%20Schedule]

If it’s in a schedule you can just do this: [image] Batch Export Schedules Revit There is no need for Python code. This functionality was already added to Dynamo’s core functionality: [image] ViewType and View.GetByType are from archi-lab package. Everything else is OOTB for 1.3 Dynamo. Cheers!

Could you be more specific what data you would lik to have so we can help you better, Greatings

Thank you both for your help. I really appreciate it. I would like to get the same information on the excel table as the information shown on the schedule and family’s parameters when you select a family. For instance: Family = Only the name of the family (Please see schedule image) Type = Only the type description (Please see schedule image) Level = Level 1 (Only the level name) Manufacturer = ACME (In this case it doesn’t exports anything) The same graph works well with Rooms and Sheets, but for some reason with Mechanical Equipment exports more data or not data at all for some parameters such as Manufacturer. I hope this provides more clarity to my problem and what I am trying to achieve. Thank you

You could also try this: [image] [image] then load the export in excel [image] Do you item every entry on purpes orde would you wan tot stack tem and cound?

Thank you for the option Spartan. The only difficulty I see with the option that you propose is that I won’t be able to import back to Revit the changes you make to the data. The graph I added to my post plus the section to import back the data from the resulting excel table works super well with Sheets and Rooms, but for some reason when you use other categories such as Mechanical Equipment or Pipe Accessories the data exported includes more data than expected or not data at all for some parameters. This is what I am having problems to understand why. Thank you

[image] liocabra: import back Oeps my bad :sweat_smile: Manby this can help: [image] Writing Data Back To A Revit Schedule From Excel FAQ I am trying to push the OOTB “Description” parameter back into the walls. I’ll test out deleting the hard returns as well. Thank you for your help. [image] Schedules to Excel and Excel to Revit using Dynamo Revit Try using list levels, right now you’re choosing the 2nd list (which contain your five 1’s). If you use list levels you could get e.g. all values on the 2nd location in each list. EDIT: Firstly you should be careful both reading and writing to the same sheet of excel in the same graph… This can cause issues for large data-sets… Also what changed from your previous post, where it didn’t assign the same values?

Mechanical Equipment to Excel

Revit

Konrad_K_Sobon June 27, 2018, 1:27pm 4

If it’s in a schedule you can just do this:

Topic		Replies	Views
Revit Schedule to Excel Bidirectional link Revit	13	11102	August 10, 2019
revit schedules with dynamo Revit revit , dynamo	1	373	March 24, 2021
Help with export/import schedules to excel - 3 questions Revit dynamo	1	421	May 8, 2019
Revit Schedule to Excel Schdule (specified cells) Revit	6	1353	October 14, 2025
Still looking for a way to Export Schedule to Excel. How about this way? Revit revit , excel , dynamo	7	3364	August 1, 2021

Mechanical Equipment to Excel

Related topics