Excel.CellPropertiesFont interface
getCellProperties
、getRowProperties、getColumnProperties のformat.fontプロパティ、または setCellProperties、setRowProperties、setColumnProperties のformat.font入力パラメーターを表します。
プロパティ
| bold |
|
| color |
|
| italic |
|
| name |
|
| size |
|
| strikethrough |
|
| subscript |
|
| superscript |
|
| tint |
|
| underline |
|
プロパティの詳細
bold
color
format.font.color プロパティを表します。
color?: string;プロパティ値
string
注釈
例
// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/42-range/cell-properties.yaml
await Excel.run(async (context) => {
const sheet = context.workbook.worksheets.getActiveWorksheet();
// Create the SettableCellProperties objects for the range.
// Create these objects once, outside the function, in your add-in.
const topHeaderProps: Excel.SettableCellProperties = {
// Set the style property to the name of an Excel style.
// The `BuiltInStyle` enum lists the built-in style names.
// A style overwrites formatting, so don't use style and format in the same object.
style: Excel.BuiltInStyle.heading1
};
const headerProps: Excel.SettableCellProperties = {
// Setting these cell properties doesn't change unspecified format subproperties.
format: {
fill: {
color: "Blue"
},
font: {
color: "White",
bold: true
}
}
};
const nonApplicableProps: Excel.SettableCellProperties = {
format: {
fill: {
pattern: Excel.FillPattern.gray25
},
font: {
color: "Gray",
italic: true
}
}
};
const matchupScoreProps: Excel.SettableCellProperties = {
format: {
borders: {
bottom: {
style: Excel.BorderLineStyle.continuous
},
left: {
style: Excel.BorderLineStyle.continuous
},
right: {
style: Excel.BorderLineStyle.continuous
},
top: {
style: Excel.BorderLineStyle.continuous
}
},
horizontalAlignment: Excel.HorizontalAlignment.center
}
};
const range = sheet.getRange("A1:E5");
// Use empty JSON objects to leave a cell's properties unchanged.
range.setCellProperties([
[topHeaderProps, {}, {}, {}, {}],
[{}, {}, headerProps, headerProps, headerProps],
[{}, headerProps, nonApplicableProps, matchupScoreProps, matchupScoreProps],
[{}, headerProps, matchupScoreProps, nonApplicableProps, matchupScoreProps],
[{}, headerProps, matchupScoreProps, matchupScoreProps, nonApplicableProps]
]);
sheet.getUsedRange().format.autofitColumns();
await context.sync();
});
italic
name
size
strikethrough
format.font.strikethrough プロパティを表します。
strikethrough?: boolean;プロパティ値
boolean
注釈
subscript
superscript
tintAndShade
underline
format.font.underline プロパティを表します。
underline?: Excel.RangeUnderlineStyle | "None" | "Single" | "Double" | "SingleAccountant" | "DoubleAccountant";プロパティ値
Excel.RangeUnderlineStyle | "None" | "Single" | "Double" | "SingleAccountant" | "DoubleAccountant"