Appending a row of data in an MS Excel file

[deanhystad]

Read the documentation for DataFrame.to_excel(). There is an argument that controls if the row index names are written to the file.

While you're at it you should take a look at glob. Would be useful for what you are doing (finding all files with extension .xlsx).

https://docs.python.org/3/library/glob.html