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.