Problems Create sheets from an Excel file

[dylanpeng]

Hi all,

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

how to fix this problem? Thanks!

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

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

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

[MJB-online]

Hi @dylanpeng,

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

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

Kind regards,
Mark

[Jonathan.Olesen]

Try this:

And to the point of @MJB-online see below:

[dylanpeng]

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
   
2. Highlight in yellow color.
   
   

[Jonathan.Olesen]

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

[dylanpeng]

It is from the SteamNodes package.

[Jonathan.Olesen]

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