# Problems Create sheets from an Excel file

**URL:** <https://forum.dynamobim.com/t/problems-create-sheets-from-an-excel-file/26111>\
**Category:** Revit\
**Tags:** revit, dynamo\
**Created:** [September 19, 2018, 5:35am UTC](https://forum.dynamobim.com/t/problems-create-sheets-from-an-excel-file/26111 "2018-09-19T05:35:56Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![dylanpeng](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/dylanpeng/32/135710_2.png) [@dylanpeng](https://forum.dynamobim.com/u/dylanpeng)\
**Post date:** [September 19, 2018, 5:35am UTC](https://forum.dynamobim.com/t/problems-create-sheets-from-an-excel-file/26111/1 "2018-09-19T05:35:57Z")

</div>

Hi all,

I don’t know why it says"Warning: List.GetItemAtIndex operation failed.  
‘int’ object is unsubscriptable"

how to fix this problem? Thanks!

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

it turns out there are two list.getatindex in my dynamo, one is original the other comes from Orchid package.

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

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

but after i replaced with the with the original one. It still doesn’t work. I don’t know why?

 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/0/a0e94621f5dae0f06fba9b8436846d002552efb7.png)

after i changing to list.deconstruct , it dosent generate the right sheet name.

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

---

<div class="post-metadata">

**Author:** ![MJB-online](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/mjb-online/32/24884_2.png) [@MJB-online](https://forum.dynamobim.com/u/MJB-online)\
**Post date:** [September 19, 2018, 7:14am UTC](https://forum.dynamobim.com/t/problems-create-sheets-from-an-excel-file/26111/2 "2018-09-19T07:14:53Z")

</div>

Hi @dylanpeng,

Your input is a nested list, so i think you need to add levels to the “List.GetItemAtIndex” node.

![Use%20levels](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/1/6/16dd59cc674ef9cff77fe6da098a4a1fd52338f0.png)

More information can be found here.  
[http://dynamobim.org/introducing-listlevel-working-with-lists-made-easier/](http://dynamobim.org/introducing-listlevel-working-with-lists-made-easier/)

Kind regards,  
Mark

---

<div class="post-metadata">

**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\
**Post date:** [September 19, 2018, 7:16am UTC](https://forum.dynamobim.com/t/problems-create-sheets-from-an-excel-file/26111/3 "2018-09-19T07:16:44Z")

</div>

Try this:  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/a/8/a886d47d162afff263b38c2e91c567e65e32d675.png)

And to the point of @MJB-online see below:  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/3/d/3dc8c64a80cad91c447af6a39a62a84a64e4035f.png)

---

<div class="post-metadata">

**Author:** ![dylanpeng](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/dylanpeng/32/135710_2.png) [@dylanpeng](https://forum.dynamobim.com/u/dylanpeng)\
**Post date:** [September 19, 2018, 7:42am UTC](https://forum.dynamobim.com/t/problems-create-sheets-from-an-excel-file/26111/4 "2018-09-19T07:42:26Z")

</div>

Thanks Jonathan&mark,

I have fixed the problem. There are two main things to fix within the script:

1. Inside the tool.createfromemptysheet.node, this script need to update to DSCore.List.Flatten  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/f/5/f5ab08818d11a90106b48097665df824dc729ef6.png)
2. Highlight in yellow color.  
 ![image](https://us1.discourse-cdn.com/flex022/uploads/dynamobim/original/3X/e/c/ec56176153826cb2d79a6081c8acdb1a5c1d4c10.png)

---

<div class="post-metadata">

**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\
**Post date:** [September 19, 2018, 7:44am UTC](https://forum.dynamobim.com/t/problems-create-sheets-from-an-excel-file/26111/5 "2018-09-19T07:44:33Z")

</div>

Out of curiosity and continuity for your topic… Which package is the “Tool.CreateEmptySheet”-node from? 🙂 Glad you fixed your issue.

---

<div class="post-metadata">

**Author:** ![dylanpeng](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/dylanpeng/32/135710_2.png) [@dylanpeng](https://forum.dynamobim.com/u/dylanpeng)\
**Post date:** [September 19, 2018, 7:46am UTC](https://forum.dynamobim.com/t/problems-create-sheets-from-an-excel-file/26111/6 "2018-09-19T07:46:35Z")

</div>

It is from the SteamNodes package.

---

<div class="post-metadata">

**Author:** ![Jonathan.Olesen](https://sea2.discourse-cdn.com/flex022/user_avatar/forum.dynamobim.com/jonathan.olesen/32/44242_2.png) [@Jonathan.Olesen](https://forum.dynamobim.com/u/Jonathan.Olesen)\
**Post date:** [September 19, 2018, 7:51am UTC](https://forum.dynamobim.com/t/problems-create-sheets-from-an-excel-file/26111/7 "2018-09-19T07:51:56Z")

</div>

I’ll just tag @Julien_Benoit1 as he is the owner of SteamNodes, to make the update of his package to 2.0 easier. 🙂
