What libraries in Python can be used to read formatted Excel, enter data and save back with the original formatting?

Question

Python

It is necessary to read the Excel template (XLSX), enter the data and save (back or to a new file), preserving the original file formatting of the original template file.
What libraries can be used to do this in Python?
PS: these libraries need to be in Python 3.4 (the last one running under Windows XP)

Answer 1

pandas

Answer 2

win32com, com automation technology (OLE Automation).
You can run the script directly on the Excel itself,
and manipulate it down to the level of individual cells.
https://github.com/search?q=win32com+excel
https://github.com/hajimef/win32com_client_excel_s...