# Issue with Excel.WritetoFile

**URL:** <https://forum.dynamobim.com/t/issue-with-excel-writetofile/40707>\
**Category:** Revit\
**Tags:** clockwork, excel\
**Created:** [September 16, 2019, 1:36pm UTC](https://forum.dynamobim.com/t/issue-with-excel-writetofile/40707 "2019-09-16T13:36:38Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![kunal](https://avatars.discourse-cdn.com/v4/letter/k/dec6dc/32.png) [@kunal](https://forum.dynamobim.com/u/kunal)\
**Post date:** [September 16, 2019, 1:36pm UTC](https://forum.dynamobim.com/t/issue-with-excel-writetofile/40707/1 "2019-09-16T13:36:38Z")

</div>

I am trying to export the list of Parameters and would like to build a excel file out of it.  
I am using the Clockwork node Document.ProjectParameters

I can export the names of all the Parameters  
And also the list of which categories each parameter is applied to.

But how do I combine the two? I fail here.

Ideally I would like to have a excel which lists:  
1.name of the parameter  
2.which category/Categories its applied to  
3.If its a type/instance parameter  
4.if its a shared parameter or otherwise

Thankyou for your interest.

 ![Revit_parameters_issue1](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/a/6ab7e6faa576735d16263e7dac0a1ec1a059ffc7.png)

---

<div class="post-metadata">

**Author:** ![cgartland](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/cgartland/32/45378_2.png) [@cgartland](https://forum.dynamobim.com/u/cgartland)\
**Post date:** [September 16, 2019, 2:15pm UTC](https://forum.dynamobim.com/t/issue-with-excel-writetofile/40707/2 "2019-09-16T14:15:29Z")

</div>

You can add the parameter name to the list of its categories using the List.AddItemToFront node. After transposing, each parameter name becomes the header for each column and all rows below the header are the categories to which the project parameters apply. See below:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/6/c/6c8c278c3b8e9203644e227130a7d73dfd046762.png)

![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/8/186e8a09c7ba47c8f0d6ae76f34491354d668b0d.png)

[export parameters.dyn](https://forum.dynamobim.com/uploads/short-url/Tl8KHtsa9vYZMsmD2rgxg249CM.dyn) (20.5 KB)

---

<div class="post-metadata">

**Author:** ![kunal](https://avatars.discourse-cdn.com/v4/letter/k/dec6dc/32.png) [@kunal](https://forum.dynamobim.com/u/kunal)\
**Post date:** [September 16, 2019, 2:52pm UTC](https://forum.dynamobim.com/t/issue-with-excel-writetofile/40707/3 "2019-09-16T14:52:01Z")

</div>

Yeah. Thanks, Transpose was the key.  
But I guess there is still an issue with the excel export.

The transpose doesnt seem to be working well.

If you notice in the screenshot, Parameter 0 is applied to two Categories 0 and 1  
In my excel export the parameter names are orderly one below the other but the Categories are haywired.

 ![Revit_parameters_issue2](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/9/f969213fd535a04ffa978dd715916a4562a86665.png)

---

<div class="post-metadata">

**Author:** ![cgartland](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/cgartland/32/45378_2.png) [@cgartland](https://forum.dynamobim.com/u/cgartland)\
**Post date:** [September 16, 2019, 3:25pm UTC](https://forum.dynamobim.com/t/issue-with-excel-writetofile/40707/4 "2019-09-16T15:25:27Z")

</div>

You should use levels in the List.AddItemToFront node–item @L1 and list @L2. This will ensure that the items are being added to the correct lists. The first list should be `[000_000_150_Fachbereich, Plane, Ansichten]` if you use the correct levels.

---

<div class="post-metadata">

**Author:** ![kunal](https://avatars.discourse-cdn.com/v4/letter/k/dec6dc/32.png) [@kunal](https://forum.dynamobim.com/u/kunal)\
**Post date:** [September 17, 2019, 7:57am UTC](https://forum.dynamobim.com/t/issue-with-excel-writetofile/40707/5 "2019-09-17T07:57:20Z")

</div>

Perfect. That worked like a charm. Thanks