Skip to content

Instantly share code, notes, and snippets.

@mrshu

mrshu/xlsxwriter_formatting_preparation.py

Created December 23, 2020 18:57
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save mrshu/c2672577c0974e0639333f39341d549c to your computer and use it in GitHub Desktop.
Save mrshu/c2672577c0974e0639333f39341d549c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
xlsxwriter_formatting_preparation.py
sheet_name = 'to_review'
excel_writer = pd.ExcelWriter("edited_questions.xlsx", engine='xlsxwriter')
df.to_excel(excel_writer, sheet_name=sheet_name, index=False)
workbook = excel_writer.book
worksheet = excel_writer.sheets[sheet_name]
green = workbook.add_format({'color': 'green'})
red = workbook.add_format({'color': 'red'})
b_green = workbook.add_format({'color': 'green', 'bold': True})
b_red = workbook.add_format({'color': 'red', 'bold': True})
default = workbook.add_format()
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment