Thank you Tomasz for your reply, on viewing your suggestions I realized that perhaps the missing element in my code was using the node String.ToNumber.
So after making some modifications, it now looks like we’re cooking with gas !! The relevant files have been uploaded below.
Anyone using the code will need to make sure they are pointing to the correct location of their .xls file.
If no families are present (as long as the family is part of the revit project file) the the code will generate new families in the position specified in the .xls file, you will need to re-run the code for it to pick up the correct sizing. If you make modifications to the .xls file and re-run the code, the changes will be reflected in the revit model.
Thank you Tomasz for putting me on the right path.
Cubes.xls (27 KB)
xLS2CUBED.dyn (35.7 KB)
CubeD.rvt (1.4 MB)