excel font size must be between 1 and 409 border

Right color right_color set_right_color() Pattern Cell pattern pattern set_pattern()īorder color border_color set_border_color()īottom color bottom_color set_bottom_color() Justify last text_justlast set_text_justlast()Ĭenter across center_across set_center_across() Protection Lock cells locked set_locked()Īlignment Horizontal align align set_align() Number Numeric format num_format set_num_format() Super/Subscript font_script set_font_script() Strikeout font_strikeout set_font_strikeout() The following table shows the Excel format categories, the formatting properties that can be applied and the equivalent object method: Category Description Property Method Name set_column ( 0, 0, 15, format ) Format methods and Format properties write_blank ( 3, 0, format )įormats can also be passed to the worksheet set_row() and set_column() methods to define the default property for a row or column. write_number ( 2, 0, 3, format ) worksheet. write_string ( 1, 0, ' Two ', format ) worksheet. write ( 0, 0, ' One ', format ) worksheet.

Once a Format object has been constructed and its properties have been set it can be passed as an argument to the worksheet write methods as follows: worksheet. The process of setting these properties is discussed in the next section. The format object holds all the formatting properties that can be applied to a cell, a row or a column. add_format ( props_hash ) # Set at creation add_format # Set properties laterįormat2 = workbook. Format objects are created by calling the workbook add_format() method as follows: format1 = workbook. Creating and using a Format objectĬell formatting is defined through a Format object. The properties of a cell that can be formatted include: fonts, colours, patterns, borders, alignment and number formatting. This section describes the methods and properties that are available for formatting cells in Excel.

Excel font size must be between 1 and 409 border