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 text…

(Shuts eyes) Area Statement export to Excel-other aproach-MKA-5.dyn (98.4 KB)

Hey Thanks. Sorry for some basic questions. Will this work on list? or I will need to do something else before applying this?

This should give you what you are after? [image] [image]

OK… will try this… one question…will this work for Areas instead of rooms? When Multiple levels are there? If some of the rooms are not on all the levels, will the fields align in a column?

I was just using rooms to extract some areas to get rid of the heading and suffix. Yes, it is all about organising your data before it get written to Excel. This is the same as the answer for question 2 it is all about organising your data.

This thread may help in organising your data…there are heaps of threads about this on the forum. [image] Organize and export sublist for Excel export? Lists-Logic Hi, I’m trying to create and export a schedule for wall panel sets to Excel. I’m able to export data of a s…

@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…

Hey, You’ve got a few options… Keep list structure, or Replace Empty (Clockwork or Orchid) should hopefully do the trick… Cheers, Mark [image]

Hi Mark Thanks for inputs. I am new to dynamo.Could you possible give some example how these nodes can be used to get the desired result?

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. Thank…

Remove some text characters from each item of lists

Uncategorized

Scott_Crichton August 27, 2018, 7:28am 10

This thread may help in organising your data…there are heaps of threads about this on the forum.

Topic		Replies	Views
Write headings on excel Uncategorized	3	944	August 3, 2020
Export first item of list as text to excel Revit excel , schedule , dynamo	7	467	December 12, 2020
Exporting list data from Dynamo To excel DesignScript	6	4813	February 3, 2022
Organization excel sheet Revit revit , excel , python , dynamo	25	839	March 15, 2020
Formatting Excel Using Dynamo Revit dynamo	17	6434	July 2, 2018

Remove some text characters from each item of lists

Related topics