I’m using Dynamo for Revit to export a Bill of Quantities to excel. For reasons related to our internal workflow, I have a pre-existing excel template that has all the required sheets already in it, and dynamo inserts the data in the correct sheet.
A lot of projects however will have several empty sheets, I am now looking for a way to delete the excel sheets that do not have any data imported in them.
I have come as far as to have a list of all the excel sheet names that can be deleted, but I can’t find any nodes or way to delete the corresponding sheets in excel. Anybody here who has an idea? I tried looking into creating my own node but unfortunately have 0 experience with python so it did not work out.