I am trying to write some string to a specified column with already placed items in some of the boxes but i get a error from my node i dont fully understand: Cannot open the Openxmlelement “newchild” beacose it is part of a tree
any idea what it could be? this is the excel file that i want to load the different strings to:
the strings that are not already inside of the specified column should be put on the underside of the list, i think it has something to do that the column already has items inside of it
The data needs to be in nested lists.
So if you want the cells from left to right, add a List.Create node between the data and the export to excel node.
If you want them below each other, use a List.Chop node to slice the list into sublists with a length of one item.
Ah ok i forgot about that, i choped my strings so they are now sublist of items of 1 but it still gives me the same error for the exportexcel node.
Try restarting the CPU if you haven’t already, and ensure no one else is in the file by writing to a new path on your local disc instead of an existing document.
it doesn’t seem possible with the OOTB OpenXML node to write to an existing Excel Table (I haven’t tried with the latest versions of Dynamo)
ah ok me neither. i also tried to get it to work with the data.exportExcel node but no luck there either i check and 1 post was talking about windows 64 bit and excel 32 bit not working correctly so looks like i have to wait for the ict to fix it for me. or it has to do that the excel i want to export the information is is a xlsm type file.
