Hi guys! I am very new to Dynamo. I found a Video on YouTube, which explains what actually I would like to do but he did not post the file. How can I have the same script? I appreciate your help! Thanks a ton!

You might have to do like following shot if you need to add names to head of columns in excel. [D1]

Here is a screenshot for the required script : -upper part to extract excel sheet contains xyz points of floor borders. -Lower part to import the excel after doing the modification of points “changing x,y,z values” and selection of the required floor type to create it. [image] Hope it Helps.

Hello Ahmad, thank you very much for the reply. Can you please post the file? I can’t find the "Data.ExportExcel in Dynamo. Which library should I install?

Thanks a lot! I try it now. You might Change the Name of it. I will post if I achieve :slight_smile:

Hello Ahmad, i tried it out but I think I did something wrong. Some coordinates are not there and some are false. It is really difficult to see in Picture from Code Block arrows are going. [Excel]

Hi Deniz, First, you should run the upper part first while you freeze the lower one to get coordinates. Second, you should freeze the upper part to run the lower part to create the new floor with the required modifications. Finally, you have to delete the old floor form the model. Try the upper …

I found the error. I had to delete the contain of first file. I created the file again but this time it Fails on importing [Import_Coord] How can I freeze the upper side?

Hi Deniz, You might Follow the Procedures I mentioned before with the below freeze process. 1- To freeze the lower part do the same with file path node. 2-To freeze the upper part … Right click on “select model element” and choose freeze. Also you might save as the exported excel and do your mod…

I started the rows from 1, may be that it takes X, Y and Z letters from file? [Import_Coord1] Cubes.xls (10.4 KB)

One more Thing: We use Project Base Coordinates. X and Y are not UCS World. They had to had N/S and E/W. How can I Switch that?

Controlling Floor Points in Excel with Dynamo

Revit

ingenieroahmad May 7, 2019, 11:13am 4

You don’t need to install any package just right click and type export in search window like below shot.

Topic		Replies	Views
Floor Coordinates Excel Import fails Revit revit , excel , geometry , dynamo	0	300	May 8, 2019
Floor by grid of points from excel Packages	4	828	February 10, 2016
Import coordinates from excel Revit excel , dynamo	12	3736	January 18, 2020
Excel to Revit on big coordinates Geometry excel	1	323	May 22, 2020
Floor doesn't have points Revit revit , excel , geometry , dynamo	8	463	July 5, 2023

Controlling Floor Points in Excel with Dynamo

Related topics