copy/pasting in excel WHILE keep file format

[zarize]

Hi guys,

I would like to copy/paste some things in excel files BUT with keeping current format of the file.

The original file is in .xls and it has some macro inside of it.
While i run the code, it does the job and save it to .xlsx, however it loses completely format and macros.

What can i do to do this task and to keep the file format?

1 2 3 4 5 6 7 8 9 10

import pandas as pd   excel = pd.read_excel(PATH\Original_file.xls, header=None) writer = pd.ExcelWriter(PATH\Test.xlsx", engine='xlsxwriter')   left_values = excel.loc[6:21, 16:22] right_values = excel.loc[6:21, 30:36] right_values = left_values   excel.to_excel(writer, 'sheet1', index=False, header=False)

In the attachment there is part of the original excel file