I’ve a create an export to excel in order to have a list of element with related spaces information. Basically with these script I’m able to have the list of spaces related to an MEP element (duct, cable tray, pipe, air terminal, etc.) If the element is crossing more than a space I can have the entire list of spaces.
For a construction company this is very useful and I’m able now to link this information to a planning but, this is not the problem.
My issue is related with the excel write node. In my Excel I’ve a deep bounces of formulas reading from a sheet which basically contains the list coming from Revit
Every time I update the model and export again, Dynamo deletes the sheet and recreate the sheet again, causing Excel to loose all the references.
The only way is to use the function replace in Excel, to relink all the references to the name of the correct sheet.
On the other side, if I’m choosing to not overwrite the excel from dynamo, I don’t have this error but, I’ve to delete manually the sheet content before exporting, in order to prevent old information to be in the sheet.
Question: Is there a way to export information to a sheet in overwrite mode, without creating a sheet from scratch?
As always thank for helping!