Style your cells in xlsxwriter using formats
Einar Stensson Einar Stensson
1.64K subscribers
24,684 views
196

 Published On Oct 11, 2017

You can use xlsxwriter to style the cells of your Excel files by creating format objects in your workbook and sending them to the write function in your worksheets.

First, you will need to create a format using the .add_format() function in your workbook. If you are curious about what kinds of formats, try sending one of the format objects available in your workbook to Python's help() function.

Second, send the format as a parameter to your worksheet's .write() function as a parameter when you enter data into your Excel file.

show more

Share/Embed