.
...
The alternating rows (highlighting added for demonstration) contain sum formulas, the SUM Excel formula. The formula is visible in the function bar below: 
The sum formula is a standard Excel function, which gets updated when ExcelWriter populates the file with data. When the data is populated, the A1:A1 reference gets updated to include all the rows of data. The result should be something like this (highlighting added for demonstration):
...