When you delete the data, the next row gets bumped up to the first row so the node always write from A1 in excel.
Try to insert a null item or see if the bumblebee node can start from NOT A1 cell when writing
Try the built in excel.writetofile node which has a value ‘overwrite’ which I believe will remove all data each time it writes. You will lose formatting though as a result. If that doesn’t work you could write twice - once with a very large set of empty strings.
Yes, but in a new sheet not a new file. You can have a printing view in the same file and change the reference to the new data each time you run the script. This way you won’t have to reformat or change much, and can always go back if the design reverses to a previous point. Only takes just some references which can be updated in excel with like 5 seconds to change if you know how to do it.
I have already tried that. Indeed, the data is completely replaced. That’s good, But when the data changes in Revit and the script is re-running, then there’s another problem:
I want to link those cells into another sheet (same file) (template) then the cells are no longer recognized. (see picture)
Instead of, ‘sheet1’, there will be #VERW, so the data is gone
I have no idea how to make that happen.
Is there a way to do this in the same dynamo file, so I can only run the entire script 1 time?
And how do I give priority to first running the empty list?