Hello All
I am very new to Dynamo. I am trying to develop script for exporting gross area schedule to excel in a table format. ( The names of the area will be in column and levels in rows). I have got the lists extracted from the areas. I am facing two problems:
How to get rid of some of the texts from the front and rear of each item.
@Scott_Crichton
Thanks for the help. I think I can manipulate the data to get desired result.
Only one problem I have is how to fill the gaps in data. (if A-1 ,A-2 or some other names are not present on some floors, the list will be shorter, so unless the lengths are matched correctly, the entries in excel columns will be misaligned. )
HI. All
Since then I have searched for some more options in the forum. Based on this I have been able to reach to this point. Refer Attached .dyn , excel and screenshot. I just need help to get levels in the first row and only one header for the areas. Request some magic touch from you guyes. Thanks in advance. Area Statement export to Excel-other aproach.dyn (51.9 KB) new.xlsx (10.0 KB)
The structure of your list create wasn’t quite right, you had the name and area as a sub-list, I’ve just even’d it out…
With the ‘only one room name’… it could be that you haven’t deleted your excel file from a previous run… each export from dynamo only updates the cells you have told it too, so if you don’t delete the old excel you get historical data left over from previous runs…
Hi.
Thanks for this. Unfortunately it is not working the way I want. Please find attached the screenshot of revit schedule and excel result I am attempting to have. Hope that clarifies the intent.new.xlsx (10.2 KB)
Hey thanks. Actually this is giving output like normal export schedule.
What I was looking for was that name of the rooms should come in columns and levels on rows , that way it is more understandable table.
I will try out this Bumble bee package definitely.