.
...
When the data is imported, the SUM formula that was in cell B4 is overwritten with one of the new values. Also, the formatting in cells A4, B3, B4, and C3 is only there because it was present in the original template. Also, the background color in row 5 was removed when the data was imported.
After
How does ExcelWriter create rows when inserting data?
What happens to things in my template, when I insert data?
Import Data (application) vs. Bind Data (template)