Edit

Share via

Excel.Interfaces.ShapeFontData interface

  • Reference
Package:
excel

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

Properties

bold

Represents the bold status of font. Returns null if the TextRange includes both bold and non-bold text fragments.
color

HTML color code representation of the text color (e.g., "#FF0000" represents red). Returns null if the TextRange includes text fragments with different colors.
italic

Represents the italic status of font. Returns null if the TextRange includes both italic and non-italic text fragments.
name

Represents font name (e.g., "Calibri"). If the text is a Complex Script or East Asian language, this is the corresponding font name; otherwise it is the Latin font name.
size

Represents font size in points (e.g., 11). Returns null if the TextRange includes text fragments with different font sizes.
underline

Type of underline applied to the font. Returns null if the TextRange includes text fragments with different underline styles. See Excel.ShapeFontUnderlineStyle for details.

Property Details

bold

Represents the bold status of font. Returns null if the TextRange includes both bold and non-bold text fragments.

bold?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

color

HTML color code representation of the text color (e.g., "#FF0000" represents red). Returns null if the TextRange includes text fragments with different colors.

color?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.9 ]

italic

Represents the italic status of font. Returns null if the TextRange includes both italic and non-italic text fragments.

italic?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.9 ]

name

Represents font name (e.g., "Calibri"). If the text is a Complex Script or East Asian language, this is the corresponding font name; otherwise it is the Latin font name.

name?: string;

Property Value

string

Remarks

[ API set: ExcelApi 1.9 ]

size

Represents font size in points (e.g., 11). Returns null if the TextRange includes text fragments with different font sizes.

size?: number;

Property Value

number

Remarks

[ API set: ExcelApi 1.9 ]

underline

Type of underline applied to the font. Returns null if the TextRange includes text fragments with different underline styles. See Excel.ShapeFontUnderlineStyle for details.

underline?: Excel.ShapeFontUnderlineStyle | "None" | "Single" | "Double" | "Heavy" | "Dotted" | "DottedHeavy" | "Dash" | "DashHeavy" | "DashLong" | "DashLongHeavy" | "DotDash" | "DotDashHeavy" | "DotDotDash" | "DotDotDashHeavy" | "Wavy" | "WavyHeavy" | "WavyDouble";

Property Value

Excel.ShapeFontUnderlineStyle | "None" | "Single" | "Double" | "Heavy" | "Dotted" | "DottedHeavy" | "Dash" | "DashHeavy" | "DashLong" | "DashLongHeavy" | "DotDash" | "DotDashHeavy" | "DotDotDash" | "DotDotDashHeavy" | "Wavy" | "WavyHeavy" | "WavyDouble"

Remarks

[ API set: ExcelApi 1.9 ]