There is a method to display the results of the program in excel:

def append_df_to_excel(self, df, sheet_name='Sheet1', startrow=None, truncate_sheet=False, **to_excel_kwargs): from openpyxl import load_workbook if 'engine' in to_excel_kwargs: to_excel_kwargs.pop('engine') writer = pd.ExcelWriter('D:\\git\\validator\\reports\\Errors.xlsx', engine='openpyxl') try: writer.book = load_workbook('D:\\git\\validator\\reports\\Errors.xlsx') if startrow is None and sheet_name in writer.book.sheetnames: startrow = writer.book[sheet_name].max_row if truncate_sheet and sheet_name in writer.book.sheetnames: idx = writer.book.sheetnames.index(sheet_name) writer.book.remove(writer.book.worksheets[idx]) writer.book.create_sheet(sheet_name, idx) writer.sheets = {ws.title: ws for ws in writer.book.worksheets} except FileNotFoundError: pass if startrow is None: startrow = 2 df.to_excel(writer, sheet_name, startrow=startrow, **to_excel_kwargs) writer.save()

The result looks like this:

This is what is displayed.

Is it possible to add the date and time of sheet creation to the right / bottom / top of the table?

  • Do you want to add a date / time when writing a DataFrame? The easiest way would be to add the date / time to the name of the sheet ( sheet ) - MaxU
  • Also as a variant - Fedor Andreevich Privalov

1 answer 1

The easiest way would be to add the date / time to the name of the sheet ( sheet ):

 append_df_to_excel('d:/temp/1.xlsx', df, sheet_name='Sheet1_{}'.format(pd.datetime.now().strftime('%Y-%m-%d %H%M%S')))

enter image description here