PandasWriter = pandas.ExcelWriter(self.sio, engine='xlsxwriter')
workbook = PandasWriter.book
worksheet = PandasWriter.sheets['Sheet1']
black_shade = workbook.add_format({'bg_color':'#f6f7f8'})
bold = workboot.add_format({'bold': True})
worksheet.set_columns('A:C',None, black_shade)
worksheet.set_rows(20, None, bold)
PandasWriter = pandas.ExcelWriter(self.sio, e