0

I'm saving Python output to existing Excel file:

with pd.ExcelWriter(xlsx_output, engine='openpyxl') as writer:
     book = openpyxl.load_workbook(xlsx_output)
     writer.book = book
     writer.sheets = dict((ws.title, ws) for ws in book.worksheets)
     df.to_excel(writer, sheet_name=outp_sheet, startrow=first_row, startcol=first_column)

However, there's a Data Table in a different sheet:

{=TABLE(;M105)}

which is somehow changed to hardcopy.

All other formulas seem to be untouched, including array formulas {=TRANSPOSE()} etc.

How could I avoid that?

Just Honza
  • 191
  • 5
  • https://stackoverflow.com/questions/38074678/append-existing-excel-sheet-with-new-dataframe-using-python-pandas – ndpu Aug 12 '21 at 13:44

0 Answers0