Python Forum

Hi guys,

I would like to do some copy paste things from one excel to another, but one of them has .xls extension.

I wanted to use openpyxl library but it says that it doesn't support old file format as xls.

Any ideas how i can achieve my goal which is "save as" file (with different extension), while keep formatting (fonts, colors), and macros?

Convert the file to xmlx, then you can use: https://openpyxl.readthedocs.io/en/stable/