# Multiple schedules export to Excel one list after other

**URL:** <https://forum.dynamobim.com/t/multiple-schedules-export-to-excel-one-list-after-other/83442>\
**Category:** Developers\
**Tags:** excel, python, dynamo\
**Created:** [November 24, 2022, 6:55am UTC](https://forum.dynamobim.com/t/multiple-schedules-export-to-excel-one-list-after-other/83442 "2022-11-24T06:55:20Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![e.cietto](https://avatars.discourse-cdn.com/v4/letter/e/d2c977/32.png) [@e.cietto](https://forum.dynamobim.com/u/e.cietto)\
**Post date:** [November 24, 2022, 6:55am UTC](https://forum.dynamobim.com/t/multiple-schedules-export-to-excel-one-list-after-other/83442/1 "2022-11-24T06:55:20Z")

</div>

Hi everyone,  
as I’m new with Dynamo, just few months I’m working with it I have a problem with nodes.  
[ATK\_DisbaZ.dyn](https://forum.dynamobim.com/uploads/short-url/LhJUIJl7Ltb2IrG82XtmwDU76x.dyn) (48.6 KB)  
I attach the node but I can’t share the project because of work privacy, but I’ll try to explain my problem.

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/8/0831247fca22acab4405771c4c4dd4473b6471a9.png)  
I have several schedules like this one and I would like to pic each of them, filter out what is not necessary, and list what I want to export to excel (which is the first part of the node, no probs with that).  
But whan I’m exporting it results to be like this:  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/c/7/c797c68e708ddd5473bd59179e195c30b7692e8d.png)

Instead of this

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/b/c/bc95784d4ab4eaf09e7d1ad9eabee556d571646a.png)  
that is what I supposed to obtain.  
It’s driving me mad, please help me guys.

 ![Node](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/9/19e54a1af81dbfc6ed0ede61572e91087a867c8e.png)

---

<div class="post-metadata">

**Author:** ![Vladimir](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/vladimir/32/147600_2.png) [@Vladimir](https://forum.dynamobim.com/u/Vladimir)\
**Post date:** [November 24, 2022, 7:35am UTC](https://forum.dynamobim.com/t/multiple-schedules-export-to-excel-one-list-after-other/83442/2 "2022-11-24T07:35:49Z")

</div>

Hi @e.cietto !  
You just have to prepare your data before writing to excel.  
Common operations for such tasks are Transpose, Cobine, Add item to front.  
If you want more help, create 3 samples of data to be combined in excel or Dynamo. So we could test it.

---

<div class="post-metadata">

**Author:** ![newshunhk](https://avatars.discourse-cdn.com/v4/letter/n/3bc359/32.png) [@newshunhk](https://forum.dynamobim.com/u/newshunhk)\
**Post date:** [November 24, 2022, 7:39am UTC](https://forum.dynamobim.com/t/multiple-schedules-export-to-excel-one-list-after-other/83442/3 "2022-11-24T07:39:19Z")

</div>

can you show us the structure in this node?

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

---

<div class="post-metadata">

**Author:** ![e.cietto](https://avatars.discourse-cdn.com/v4/letter/e/d2c977/32.png) [@e.cietto](https://forum.dynamobim.com/u/e.cietto)\
**Post date:** [November 24, 2022, 7:54am UTC](https://forum.dynamobim.com/t/multiple-schedules-export-to-excel-one-list-after-other/83442/4 "2022-11-24T07:54:12Z")

</div>

[Sample.dyn](https://forum.dynamobim.com/uploads/short-url/a2lhWw6mrsEo18bmWhGiI0IgNb6.dyn) (41.1 KB)  
Hi Vladimir,  
here’s a sample with letters instead of values, but still the same problem.  
This:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/9/0/90a0c0177239bef89a06e231f5caaee7ad9ebffe.png)  
Instead of:  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/8/6/86a9e00f433bd9af1c6771b657aac3a6e3cf0492.png)

See if you could come out with something I’m really desperate ah ah

---

<div class="post-metadata">

**Author:** ![e.cietto](https://avatars.discourse-cdn.com/v4/letter/e/d2c977/32.png) [@e.cietto](https://forum.dynamobim.com/u/e.cietto)\
**Post date:** [November 24, 2022, 7:57am UTC](https://forum.dynamobim.com/t/multiple-schedules-export-to-excel-one-list-after-other/83442/5 "2022-11-24T07:57:58Z")

</div>

Sure here it is

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

---

<div class="post-metadata">

**Author:** ![Vladimir](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/vladimir/32/147600_2.png) [@Vladimir](https://forum.dynamobim.com/u/Vladimir)\
**Post date:** [November 24, 2022, 8:17am UTC](https://forum.dynamobim.com/t/multiple-schedules-export-to-excel-one-list-after-other/83442/7 "2022-11-24T08:17:28Z")

</div>

try, edited to add spaces:  
[Sample.dyn](https://forum.dynamobim.com/uploads/short-url/kcj1MiOHz6NtsTU35FDSc72t5DX.dyn) (60.5 KB)

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/4/4/440803f5d9ba934e3b2232d1370200a4323ebc77.png)

---

<div class="post-metadata">

**Author:** ![e.cietto](https://avatars.discourse-cdn.com/v4/letter/e/d2c977/32.png) [@e.cietto](https://forum.dynamobim.com/u/e.cietto)\
**Post date:** [November 24, 2022, 8:29am UTC](https://forum.dynamobim.com/t/multiple-schedules-export-to-excel-one-list-after-other/83442/8 "2022-11-24T08:29:18Z")

</div>

Hi Vladimir,  
I tried it but it didn’t write anything, and trying to read the Excel content with “read Excel” it gives me this result

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/2/d/2de9e234901320aff70793bb9ac4b106ecc7a2b5.png)

---

<div class="post-metadata">

**Author:** ![Vladimir](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/vladimir/32/147600_2.png) [@Vladimir](https://forum.dynamobim.com/u/Vladimir)\
**Post date:** [November 24, 2022, 8:33am UTC](https://forum.dynamobim.com/t/multiple-schedules-export-to-excel-one-list-after-other/83442/9 "2022-11-24T08:33:10Z")

</div>

Do not Read and Write from/to same files at one time.

---

<div class="post-metadata">

**Author:** ![e.cietto](https://avatars.discourse-cdn.com/v4/letter/e/d2c977/32.png) [@e.cietto](https://forum.dynamobim.com/u/e.cietto)\
**Post date:** [November 24, 2022, 9:52am UTC](https://forum.dynamobim.com/t/multiple-schedules-export-to-excel-one-list-after-other/83442/11 "2022-11-24T09:52:18Z")

</div>

Works perfectly thx a lot you made my day
