Overwrite existing data without overwriting the data and formatting in the rows above the existing data via FME Excel Writer

Truncate will remove all data from a table. So if you want to truncate, you’ll have to read and rewrite the first 5 rows.

As an alternative, you can use a FeatureWriter to delete specific rows, excluding the first 5 rows, and then another FeatureWriter to instert the new rows.

I actually went a different route.  I figured out how to use a template within each writer for the 3 sheets that are being output to my final Excel file.  I set the first Writer for the Fatal Review to use a parameter so the user can set the Destination File location and name.  And within the Writer Parameters, the Overwrite Existing File is set to “Yes”.  The next two writers for the Buffer Review and CoC Review, are set to use whatever parameter the user input for the file name and destination from the Fatal Review Writer.  And within the Writer Parameters for those two the Overwrite Existing File is set to “No”.  This keeps the template file as is, and writes a new file, that follows the format and schema of the template file and starts inputting the data at row 5 from all three writers.  Overall this is a much better solution for my needs.  See below images.