# Sorting List - Revit schedule to Excel

**URL:** <https://forum.dynamobim.com/t/sorting-list-revit-schedule-to-excel/12078>\
**Category:** Revit\
**Created:** [May 29, 2017, 12:34am UTC](https://forum.dynamobim.com/t/sorting-list-revit-schedule-to-excel/12078 "2017-05-29T00:34:00Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![rad1cal](https://avatars.discourse-cdn.com/v4/letter/r/8edcca/32.png) [@rad1cal](https://forum.dynamobim.com/u/rad1cal)\
**Post date:** [May 29, 2017, 12:34am UTC](https://forum.dynamobim.com/t/sorting-list-revit-schedule-to-excel/12078/1 "2017-05-29T00:34:00Z")

</div>

Hi Everyone

I’ve just been working on a script which populates an excel drawing transmittal based on the project information and drawing sheet schedule in Revit. I just can’t quite get the sorting correct -

This is the schedule in Revit, as I want it to appear in Excel (In ascending order of sheet numbers);

![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/d/9d676b35838045276f5fc3d487f15a0dbddf7399.PNG)

And here is the output from dynamo;

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

I’ve been playing with SortIndexByValue, Sort, and SortByFucntion, but can’t seem to get anything to work for me, any ideas?

Here’s the script;

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/2/02f682804534014c4134786d1d7f17024f61a560.PNG)

---

<div class="post-metadata">

**Author:** ![Kulkul](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/kulkul/32/49801_2.png) [@Kulkul](https://forum.dynamobim.com/u/Kulkul)\
**Post date:** [May 29, 2017, 4:12am UTC](https://forum.dynamobim.com/t/sorting-list-revit-schedule-to-excel/12078/2 "2017-05-29T04:12:34Z")

</div>

Hi @rad1cal

Could you please drop your dummy revit file with only drawing sheet list on it.

---

<div class="post-metadata">

**Author:** ![Konrad\_K\_Sobon](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/konrad_k_sobon/32/8838_2.png) [@Konrad\_K\_Sobon](https://forum.dynamobim.com/u/Konrad_K_Sobon)\
**Post date:** [May 29, 2017, 4:07pm UTC](https://forum.dynamobim.com/t/sorting-list-revit-schedule-to-excel/12078/3 "2017-05-29T16:07:23Z")

</div>

In Dynamo 1.3 there is a node called ViewSchedule.Export. That should take care of all your needs.

---

<div class="post-metadata">

**Author:** ![rad1cal](https://avatars.discourse-cdn.com/v4/letter/r/8edcca/32.png) [@rad1cal](https://forum.dynamobim.com/u/rad1cal)\
**Post date:** [May 30, 2017, 1:01am UTC](https://forum.dynamobim.com/t/sorting-list-revit-schedule-to-excel/12078/4 "2017-05-30T01:01:19Z")

</div>

Thanks very much Konrad,  
I’ve had a play with ScheduleView.Export, am I on the right track here? (Sorry I’m still a bit new to all this)  
I’m after the schedule titled “Drawing Sheet List”.

 ![](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/4/a4ed05ccd3db23a3d6d97d45aebed61a243510f8.PNG)

---

<div class="post-metadata">

**Author:** ![Konrad\_K\_Sobon](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/konrad_k_sobon/32/8838_2.png) [@Konrad\_K\_Sobon](https://forum.dynamobim.com/u/Konrad_K_Sobon)\
**Post date:** [May 30, 2017, 1:36am UTC](https://forum.dynamobim.com/t/sorting-list-revit-schedule-to-excel/12078/5 "2017-05-30T01:36:16Z")

</div>

missing export options input…

---

<div class="post-metadata">

**Author:** ![rad1cal](https://avatars.discourse-cdn.com/v4/letter/r/8edcca/32.png) [@rad1cal](https://forum.dynamobim.com/u/rad1cal)\
**Post date:** [May 30, 2017, 5:17am UTC](https://forum.dynamobim.com/t/sorting-list-revit-schedule-to-excel/12078/6 "2017-05-30T05:17:06Z")

</div>

I’m not sure what I’ve got to do for exportOptions, what do I need for an input into that node? It says that if nothing is supplied, the default will be used?

---

<div class="post-metadata">

**Author:** ![Konrad\_K\_Sobon](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/konrad_k_sobon/32/8838_2.png) [@Konrad\_K\_Sobon](https://forum.dynamobim.com/u/Konrad_K_Sobon)\
**Post date:** [May 30, 2017, 3:44pm UTC](https://forum.dynamobim.com/t/sorting-list-revit-schedule-to-excel/12078/7 "2017-05-30T15:44:21Z")

</div>

Search for “Export Options” or look under ViewSchedule tab in the library.

Also, if you want to use defaults, then perhaps try right-clicking on the exportOptions input and check the option to use default value.

---

<div class="post-metadata">

**Author:** ![arvin.nunez](https://avatars.discourse-cdn.com/v4/letter/a/2acd7d/32.png) [@arvin.nunez](https://forum.dynamobim.com/u/arvin.nunez)\
**Post date:** [August 8, 2017, 3:45pm UTC](https://forum.dynamobim.com/t/sorting-list-revit-schedule-to-excel/12078/8 "2017-08-08T15:45:57Z")

</div>

![Revit View Schedule to Excel](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/8/1845e98b42339c3576ae86ed139e2d8d950af257.png)  
Hi,  
I’m new to Dynamo also, I came up with this from fishing with other Topics in this forum. Please see image.  
Hope this help
