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.

[erfajo]

@dylanpeng

my nodes doesnt work exactly in the same way as the OOTB nodes do, There should be several examples on the difference for the node you are addressing. If you cannot find the proper information, then check my profile to see how you handle issues with Orchid nodes.