xlsgen > overview > Font

Font options is one of the main and most efficient technique used to show a nice report table and underlines key elmeents out of an otherwise string of cells.

Font options are accessed by right-clicking on a cell and choosing Format Cell and then clicking on the Font tab. The most common font options are also provided in the formatting toolbar.

Among properties that can be affected are :

• the font itself, identified by its name. Please note xlsgen does not embed font glyphs in an Excel file. As a result, xlsgen provides no warranty on the ubiquity of Excel files that would use particular or custom fonts.
• the font size, expressed in pixels
• the font style, including bold, italic and strikeout
• the underline style. See enumUnderline for more information.
• the exponent style. See enumExponent for more information.
• the color. Any RGB color can be used. See enumColorPalette for more information.
• the font family and charset.

Font options are properties of the current style object. See formatting for more information. The regular programming interface for the font properties is the IXlsFont interface.

In order to produce the result above, you need to execute the following code :

Dim style As IXlsStyle
Set style = wksht.NewStyle

style.Alignment.Horizontal = halign_left
style.Font.Color = &HFF6666
style.Font.Italic = True
style.Font.Size = 12
style.Font.Underlined = fontunderline_simple
style.Apply

wksht.Float(3, 2) = 5 ' put 5.00 in row 3, column 2

IXlsStyle style = wksht.NewStyle();

style.Alignment.Horizontal = xlsgen.enumHorizontalAlignment.halign_left;
style.Font.Color = 0xFF6666;
style.Font.Italic = 1;
style.Font.Size = 12;
style.Font.Underlined = xlsgen.enumUnderline.fontunderline_simple;
style.Apply();

wksht.set_Float(3, 2, 5.0); // put 5.00 in row 3, column 2

xlsgen::IXlsStylePtr style = wksht->NewStyle();

style->Alignment->Horizontal = xlsgen::halign_left;
style->Font->Color = 0xFF6666;
style->Font->Italic = TRUE;
style->Font->Size = 12;
style->Font->Underlined = xlsgen::fontunderline_simple;
style->Apply();

wksht->Float[3][2] = 5.0; // put 5.00 in row 3, column 2