# Dynamo opening multiple excel files

**URL:** <https://forum.dynamobim.com/t/dynamo-opening-multiple-excel-files/76800>\
**Category:** Civil 3D\
**Tags:** excel, dynamo, civil3d\
**Created:** [May 23, 2022, 8:32am UTC](https://forum.dynamobim.com/t/dynamo-opening-multiple-excel-files/76800 "2022-05-23T08:32:48Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![remco.dejong](https://avatars.discourse-cdn.com/v4/letter/r/f05b48/32.png) [@remco.dejong](https://forum.dynamobim.com/u/remco.dejong)\
**Post date:** [May 23, 2022, 8:32am UTC](https://forum.dynamobim.com/t/dynamo-opening-multiple-excel-files/76800/1 "2022-05-23T08:32:48Z")

</div>

Hi,  
So a little problem occured while I was working on my dynamo model. The model has as result that 38 empty excel files are getting start up (probaly more, but my pc cant handle crashes at this amount). Which is weird cause it didn’t do this before. My guess is that the problem occurs by the following part:

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/0/3/032ba4d148913ed16b10fb641162c46409dd816e.png)  
I think the problem lays somewhere in this part cause it didn’t crash when I didn’t have this part included. Another possibility is that it crashes because of the data.exportToExcel, this node gives an error (HRESULT: 0x800A03EC) but I couldnt figure out what this error meant.  
Any way how to solve this problem?

---

<div class="post-metadata">

**Author:** ![Draxl\_Andreas](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/draxl_andreas/32/145744_2.png) [@Draxl\_Andreas](https://forum.dynamobim.com/u/Draxl_Andreas)\
**Post date:** [May 23, 2022, 8:58am UTC](https://forum.dynamobim.com/t/dynamo-opening-multiple-excel-files/76800/2 "2022-05-23T08:58:31Z")

</div>

set the boolen to false… so they start up @remco.dejong ,

can you show the whole graph? and the error message

KR

Andreas

---

<div class="post-metadata">

**Author:** ![remco.dejong](https://avatars.discourse-cdn.com/v4/letter/r/f05b48/32.png) [@remco.dejong](https://forum.dynamobim.com/u/remco.dejong)\
**Post date:** [May 23, 2022, 9:05am UTC](https://forum.dynamobim.com/t/dynamo-opening-multiple-excel-files/76800/3 "2022-05-23T09:05:04Z")

</div>

It already did start up, that isnt the problem. But I’m 99,9% sure I did find the problem.

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/8/a85be4f926c5282fc91d292f501eea86530f2fd0.png)  
It puts a list inside of a list which makes it impossible to put it inside 1 excel column. Any idea on how I can prevent/solve this?  
Edit, different screenshot

---

<div class="post-metadata">

**Author:** ![Draxl\_Andreas](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/draxl_andreas/32/145744_2.png) [@Draxl\_Andreas](https://forum.dynamobim.com/u/Draxl_Andreas)\
**Post date:** [May 23, 2022, 9:12am UTC](https://forum.dynamobim.com/t/dynamo-opening-multiple-excel-files/76800/4 "2022-05-23T09:12:18Z")

</div>

@remco.dejong

can you try transpose or(and) flatten

---

<div class="post-metadata">

**Author:** ![remco.dejong](https://avatars.discourse-cdn.com/v4/letter/r/f05b48/32.png) [@remco.dejong](https://forum.dynamobim.com/u/remco.dejong)\
**Post date:** [May 23, 2022, 9:17am UTC](https://forum.dynamobim.com/t/dynamo-opening-multiple-excel-files/76800/5 "2022-05-23T09:17:55Z")

</div>

Thanks, list.flatten did the job.
