Write to excel node only populating one column?

1

Hi… I am trying to create a graph that writes two separate pieces of information into difference cells of an excel sheet, so I use the “Excel.WriteToFile” node twice separately at the end of the graph, but when it runs, only one of the nodes seems to populate into excel.

Does anyone know why this happens ?

Screenshot
Screenshot.PNG1266×856 92.5 KB

The nodes appear to have done their job but only one set of information appears into excel.

Thanks

2

you need just one excel write node.
you need to make one list of all data with the list create node
you need a list transpose node to change excel columns into rows and vice versa

3

Thanks Marcel but I have got it to work by changing the “overwrite” to false.

The graph isn’t pretty and your way may be better but at least I seem to have got it doing what I want (for now anyway).

1 Like