I’m trying to make the following flow work:

The flow should make a sheet-list from Revit and that’s what actually is working, though I want that sheet-list to be update able.

Therefore I’ve placed a pass through node at the end, but somehow this doesn’t work.
Does anyone know what I’m doing wrong?

The contents of the excel file should be erased before it’s filled with new information.tekeningenlijst.dyn (70.8 KB)

What does the error say? If I understand you correctly you could just set overwrite to true.

with overwrite the format of the sheet in excel will be overwritten and all format will be lost. that’s not what i’m looking for

The trick I use is to just use another sheet in excel that is formatted where it looks up a dynamo “overwritten” sheet. I find just data dumping to a formatted excel sheet to be easier to deal with. (I use vba in my excel sheets to pull and push between an import and export sheets for dynamo)

1 Like

This is usually a good option when using formatted cells. Have one sheet for dumping data and another formatted sheet that reads the data.

To answer your question though, I’m guessing the “clearing” only happens once and then doesn’t run again because there is nothing in that section that updates. You could use something like the Was Run output as the boolean input for Clear Content.