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
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.
test excel.dyn (28.2 KB) I want to reach to this result
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.
Set the lacing to longest in the List.AddItemToFront node.
Right click on the node > Lacing > Longest
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?
wait, something is wrong with that
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.
And the excel is exporting ok?
yes It’s okay just I need to add family name and divide number to each family
I had to change some stuff in order to get it right:
And here is the excel
Sorry about the mess…
yes yes thank you @m.souza can you help me to add family types to list
Yes, I’m not sure what you mean though. Can you show me an example of how the excel file would look like?
something like this
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:
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