comment Comment attached to cell
hyperlink
Hyperlink or email address as string object
alignment
Text/value alignment for display
color
Cell color
df
Lets you write a pandas DataFrame object directly to the spreadsheet
Table 12-3 shows typesetting options for the Cell object. All options are attributes of the
font object, which is a property of the Cell object. For example, this:
Cell(“A1”).font.size = 15
sets a (new) font size.
Table 12-3. DataNitro Cell typesetting options
Attribute Description
size
Font size
color
Font color
bold
Bold font via Cell(“A1”).font.bold=True
italic
Italic font
underline
Underlines text
strikethrough
Puts strikethrough line through text
subscript
Subscripts text
superscript
Superscripts text
Finally, there are also a couple of methods for the Cell object. They are listed in Table 12-
4.
Table 12-4. DataNitro Cell methods
Attribute Description
