Hey there,
I’m trying to assign multiple parameters to multiple sheets at the same time from an Excel file but I can’t understand why my script is not working. Here’s a picture of my script and excel file. I’d appreciate it if anyone could let me know what is wrong!
Try to set the lacing on the last node to Cross Product
Did that but it doesn’t work. it sets one same value for all parameters.
Lacing and list levels will have to be adjusted.
The elements you want to manipulate are the individual items in the list, so level 1.
The parameter names and values are sublists, so level 2.
There is only one set of parameter names, but many elements and values, so longest lacing.
Note that you don’t have any association from sheets to the excel data, so the resulting values may not be what you expect (ie: what you though would go on sheet A1 might go on sheet A5), as it’s just order of creation at the moment.
You could count the sheets from the all elements of catgegory node and then run your inputs through a cycle node so that you have the duplicate values to match the number of sheets
