excel_file = 'myfile.xlsx'
writer = pd.ExcelWriter(excel_file, engine='xlsxwriter')
df.to_excel(writer, sheet_name='main')
df.count().to_excel(writer, sheet_name='counts')
writer.save()