Hello Everyone!
I have a project, where my sheet numbers are created from six different parameters. I need to hand out a sheet list.
I’m triing to export all of these six parameters from my project and insert them into excel separeted by a “-” sign.
Final result should look like something like this:
What is the best way to do it?
A series of Element.getParameterValueByName and a List.OfRepeated items node.
Combine all lists into one with a list.Create node.
List.Transpose and write to excel.
Oh, okay. Thank you for your answer!
Thats what i did. I was just hoping for some nicer solution. 
Is there a good way to add the “-” signs with a CodeBlock?
What i mean, that i count my sheets. Feed this number into the CodeBlock to get the length, then make a list with “Length” number of “-” signs without List.OfRepeated item?
You can actually call all of these functions in a single code block, and use them in a single calculation.
List.Transpose(
{
x,
List.OfRepeatedItem("-", List.Count(x)),
y
}
);
X is your first list of parameter values.
Y is your second list of parameter values.
You can even get the parameter values in the same calculation if you’re ambitious.
Thank you!
Welcome!