Problem
Users often get confused about which Save Mode to use when writing Excel files. Choosing the wrong option can overwrite important sheets or cause duplicate data.
Explanation
The Save Excel Advanced node provides multiple save modes to handle different real-world scenarios.
OverwriteFile
-
Deletes the entire existing Excel file.
-
Creates a brand-new workbook.
-
Use this when the file is disposable or fully regenerated.
Best for: Batch reports, regenerated outputs, temporary exports.
OverwriteSheet
-
Replaces only the specified sheet.
-
Keeps all other sheets untouched.
-
Required when Preserve Formatting is enabled.
Best for:
-
Excel templates
-
Dashboards with formulas
-
Reports with charts and formatting
AppendSheet
-
Adds new rows below existing data.
-
Does not rewrite headers unless explicitly enabled.
Best for:
-
Daily transaction logs
-
Audit trails
-
Incremental reporting
Recommendation
If you are unsure:
-
Template-based reports → OverwriteSheet
-
Daily incremental data → AppendSheet
-
Fresh exports → OverwriteFile