An Excel “font” contains the details of not only what is normally considered a font, but also several other display attributes. Items correspond to those in the Excel UI’s Format/Cells/Font tab.
1 = Characters are bold. Redundant; see “weight” attribute.
| Value | Character Set |
|---|---|
| 0 | ANSI Latin |
| 1 | System default |
| 2 | Symbol |
| 77 | Apple Roman |
| 128 | ANSI Japanese Shift-JIS |
| 129 | ANSI Korean (Hangul) |
| 130 | ANSI Korean (Johab) |
| 134 | ANSI Chinese Simplified GBK |
| 136 | ANSI Chinese Traditional BIG5 |
| 161 | ANSI Greek |
| 162 | ANSI Turkish |
| 163 | ANSI Vietnamese |
| 177 | ANSI Hebrew |
| 178 | ANSI Arabic |
| 186 | ANSI Baltic |
| 204 | ANSI Cyrillic |
| 222 | ANSI Thai |
| 238 | ANSI Latin II (Central European) |
| 255 | OEM Latin I |
An explanation of “colour index” is given in the Formatting section at the start of this document.
1 = Superscript, 2 = Subscript.
| Value | Famliy |
|---|---|
| 0 | None (unknown or don’t care) |
| 1 | Roman (variable width, serifed) |
| 2 | Swiss (variable width, sans-serifed) |
| 3 | Modern (fixed width, serifed or sans-serifed) |
| 4 | Script (cursive) |
| 5 | Decorative (specialised, for example Old English, Fraktur) |
The 0-based index used to refer to this Font() instance. Note that index 4 is never used; xlrd supplies a dummy place-holder.
Height of the font (in twips). A twip = 1/20 of a point.
Characters are italic
The name of the font. Example: “Arial”
1 = Font is outline style (Macintosh only)
1 = Font is shadow style (Macintosh only)
1 = Characters are struck out.
| Value | Underline Type |
|---|---|
| 0 | None |
| 1 | Single |
| 0x21 (33) | Single accounting |
| 2 | Double |
| 0x22 (34) | Double accounting |
1 = Characters are underlined. Redundant; see “underline_type” attribute.
Font weight (100-1000). Standard values are 400 for normal text and 700 for bold text.</p>