Edit

Share via


Excel.Interfaces.RangeFontData interface

An interface describing the data returned by calling rangeFont.toJSON().

Remarks

Used by

Properties

bold

Represents the bold status of the font.

color

HTML color code representation of the text color (e.g., #FF0000 represents Red).

italic

Specifies the italic status of the font.

name

Font name (e.g., "Calibri"). The name's length should not be greater than 31 characters.

size

Font size.

strikethrough

Specifies the strikethrough status of font. A null value indicates that the entire range doesn't have a uniform strikethrough setting.

subscript

Specifies the subscript status of font. Returns true if all the fonts of the range are subscript. Returns false if all the fonts of the range are superscript or normal (neither superscript, nor subscript). Returns null otherwise.

superscript

Specifies the superscript status of font. Returns true if all the fonts of the range are superscript. Returns false if all the fonts of the range are subscript or normal (neither superscript, nor subscript). Returns null otherwise.

tintAndShade

Specifies a double that lightens or darkens a color for the range font. The value is between -1 (darkest) and 1 (brightest), with 0 for the original color. A null value indicates that the entire range doesn't have a uniform font tintAndShade setting.

underline

Type of underline applied to the font. See Excel.RangeUnderlineStyle for details.

Property Details

bold

Represents the bold status of the font.

bold?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.1

color

HTML color code representation of the text color (e.g., #FF0000 represents Red).

color?: string;

Property Value

string

Remarks

API set: ExcelApi 1.1

italic

Specifies the italic status of the font.

italic?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.1

name

Font name (e.g., "Calibri"). The name's length should not be greater than 31 characters.

name?: string;

Property Value

string

Remarks

API set: ExcelApi 1.1

size

Font size.

size?: number;

Property Value

number

Remarks

API set: ExcelApi 1.1

strikethrough

Specifies the strikethrough status of font. A null value indicates that the entire range doesn't have a uniform strikethrough setting.

strikethrough?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.9

subscript

Specifies the subscript status of font. Returns true if all the fonts of the range are subscript. Returns false if all the fonts of the range are superscript or normal (neither superscript, nor subscript). Returns null otherwise.

subscript?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.9

superscript

Specifies the superscript status of font. Returns true if all the fonts of the range are superscript. Returns false if all the fonts of the range are subscript or normal (neither superscript, nor subscript). Returns null otherwise.

superscript?: boolean;

Property Value

boolean

Remarks

API set: ExcelApi 1.9

tintAndShade

Specifies a double that lightens or darkens a color for the range font. The value is between -1 (darkest) and 1 (brightest), with 0 for the original color. A null value indicates that the entire range doesn't have a uniform font tintAndShade setting.

tintAndShade?: number;

Property Value

number

Remarks

API set: ExcelApi 1.9

underline

Type of underline applied to the font. See Excel.RangeUnderlineStyle for details.

underline?: Excel.RangeUnderlineStyle | "None" | "Single" | "Double" | "SingleAccountant" | "DoubleAccountant";

Property Value

Excel.RangeUnderlineStyle | "None" | "Single" | "Double" | "SingleAccountant" | "DoubleAccountant"

Remarks

API set: ExcelApi 1.1