Organization excel sheet

Revit
, , ,
1

Hi, I am trying to export an Excel sheet included “Room Name, Room Area, Type of Furniture in Room, Number of Furniture in Room” it worked but not included Type of Furniture in Room >> or maybe I need a way to rename the title of lists in excel so I need to convert 1 to 2 as images below

image
image1107×577 177 KB
image image

2

@jacob.small @Nick_Boyts can you help me, please?

3

Hi MAIA,
I´m not sure exactly what you need. If it’s to get the column titles exported you’ll need them included in the data.
Here is a simple way to do that. Let us know what else you’re trying to achieve.

image
image792×756 111 KB

4

It’s not working I think I need to make semi flatten to the list or just rename the title of lists

image
image841×520 186 KB

5

test excel.dyn (28.2 KB) I want to reach to this result image

6

You have to “rewire”.
The inputs for List.AddItemToFront:
In item you should connect the titles you have listed in List.Create node (the one you are using with Element.GetParameterValueByName);
In list you connect the data you have in the List.Map function.
Make sure to set the lacing to longest in the List.AddItemToFront node.

7

image
image645×530 154 KB
I did but It set in the first as a separated list also I want to add Family name to the list I sent to you dyn file to imagine what I want

8

Set the lacing to longest in the List.AddItemToFront node.
Right click on the node > Lacing > Longest

9

I did but it’s the same result also I have a problem in sorting data like this the list 0 = = list 3 on mapping I need to make them has the same index do you get it my point?

image
image756×548 121 KB

10

Sorry, I didn’t notice this before, you have to transpose the list of data:

image
image1448×691 187 KB

11

wait, something is wrong with that

12

ok, it worked thanks a lot, just I want to add family type to the list I think every family will have a separated list.

image
image1111×564 164 KB

13

And the excel is exporting ok?

14

image
yes It’s okay just I need to add family name and divide number to each family

15

Ok.
I had to change some stuff in order to get it right:

image
image1494×761 203 KB

And here is the excel

image

Sorry about the mess…

1 Like
16

yes yes thank you @m.souza can you help me to add family types to list

17

Yes, I’m not sure what you mean though. Can you show me an example of how the excel file would look like?

18

image
something like this

19

Ok, I think I get what you´re thinking. In some point you might get repeated rooms in your table, right?
There is this node from Clockwork that migth help to get the data:

image
image1080×635 140 KB

1 Like
20

yes yes, this what I mean actually but we need to make sort lists as output from" groups "have a different sort according to List.Map image