Cells are formatted for various reasons. In the business world, they are used to group data based on a theme, or in the case of a software development process, cells are colored to indicate whether a feature is done or a bug is fixed.
For this recipe, we will use the same
xlsxwriter module and format the cells. We will learn how to add and apply formats to the cells.
add_format()method. This method returns a
formatobject. The following code example shows how to create a format:
format = workbook.add_format() format.set_bold() format.set_font_color('green') ...