I am working on dynamo script for socket list to exported from electrical model in specified excel file in a specific cell as per type of socket and count of it for ex. F1, F2, F3…so on.
for better understanding I am attaching a snap here as expected result in excel.
Whatever I have tried so far also attached here.
however, I am not finding way to move further. whether it is possible in dynamo?
I don’t know why you use two Data.ExportToExcel nodes. For testing maybe?
In the end you only need one.
Make sure you list structure is correct and of equal length for the data input.
thanks for your reply. Yes, that two nodes were for testing only.
I agree with you to have only on export node in the end.
However, what I need is to export socket tags as per their type to be exported in respective column in excel.
any idea how this can be done?
You have to organize your lists in such a way your different Parameters values ends up at the right index in each sublist. So in example
0 = allways level
1 = allways room
2 = allways number
etc.