Excel.CellPropertiesFillLoadOptions interface
指定要在 对象上 format.fill 加载的属性。
属性
| color | 指定是否加载 |
| pattern | 指定是否加载 |
| pattern |
指定是否加载 |
| pattern |
指定是否加载 |
| tint |
指定是否加载 |
属性详细信息
color
指定是否加载 color 属性。
color?: boolean;属性值
boolean
注解
示例
// 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 cell = context.workbook.getActiveCell();
// Define the cell properties to get by setting the matching LoadOptions to true.
const propertiesToGet = cell.getCellProperties({
address: true,
format: {
fill: {
color: true
},
font: {
color: true
}
},
style: true
});
// Sync to get the data from the workbook.
await context.sync();
const cellProperties = propertiesToGet.value[0][0];
console.log(
`Address: ${cellProperties.address}\nStyle: ${cellProperties.style}\nFill Color: ${cellProperties.format.fill.color}\nFont Color: ${cellProperties.format.font.color}`);
});