Modelling piles from excel with varying x,y,z coords and lengths using dynamo for the 1st time. (unsure how to change the lengths)

you are almost there…!

Assuming your pile family has got a parameter “PileLength” you’d just duplicate the SetParameterByName node, and change the parameter name from “Mark” to “PileLength”

It looks like you are using GetItemAtIndex =11 for the value

seems to be errors?

You need to read what the error says, and then adjust the input as needed. We do not have a clue what your error is indicating.

EG if the parameter storage type is a string then you need to put in a string not a number.

Then similar the other way if it requires a number but you put in a string.