Excel.CellPropertiesFill interface

Paket:

excel

Stellt die format.fill Eigenschaften vongetCellProperties ,getRowProperties und oder getColumnProperties den format.fill Eingabeparametern von setCellProperties,setRowProperties und dar.setColumnProperties

Hinweise

[ API-Satz: ExcelApi 1.9 ]

Eigenschaften

color	Stellt die format.fill.color Eigenschaft dar.
pattern	Stellt die format.fill.pattern Eigenschaft dar.
patternColor	Stellt die format.fill.patternColor Eigenschaft dar.
patternTintAndShade	Stellt die format.fill.patternTintAndShade Eigenschaft dar.
tintAndShade	Stellt die format.fill.tintAndShade Eigenschaft dar.

Details zur Eigenschaft

color

Stellt die format.fill.color Eigenschaft dar.

color?: string;

Eigenschaftswert

string

Hinweise

[ API-Satz: ExcelApi 1.9 ]

Beispiele

// 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();

    // Creating the SettableCellProperties objects to use for the range.
    // In your add-in, these should be created once, outside the function.
    const topHeaderProps: Excel.SettableCellProperties = {
        // The style property takes a string matching the name of an Excel style.
        // Built-in style names are listed in the `BuiltInStyle` enum.
        // Note that a style will overwrite any formatting,
        // so do not use the format property with the style property.
        style: "Heading1"
    };

    const headerProps: Excel.SettableCellProperties = {
        // Any subproperties of format that are not set will not be changed when these cell properties are set.
        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
                }
            }
        }
    };

    const range = sheet.getRange("A1:E5");

    // You can use empty JSON objects to avoid changing a cell's properties.
    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();
});

pattern

Stellt die format.fill.pattern Eigenschaft dar.

pattern?: Excel.FillPattern | "None" | "Solid" | "Gray50" | "Gray75" | "Gray25" | "Horizontal" | "Vertical" | "Down" | "Up" | "Checker" | "SemiGray75" | "LightHorizontal" | "LightVertical" | "LightDown" | "LightUp" | "Grid" | "CrissCross" | "Gray16" | "Gray8" | "LinearGradient" | "RectangularGradient";

Eigenschaftswert

Excel.FillPattern | "None" | "Solid" | "Gray50" | "Gray75" | "Gray25" | "Horizontal" | "Vertical" | "Down" | "Up" | "Checker" | "SemiGray75" | "LightHorizontal" | "LightVertical" | "LightDown" | "LightUp" | "Grid" | "CrissCross" | "Gray16" | "Gray8" | "LinearGradient" | "RectangularGradient"

Hinweise

[ API-Satz: ExcelApi 1.9 ]

patternColor

Stellt die format.fill.patternColor Eigenschaft dar.

patternColor?: string;

Eigenschaftswert

string

Hinweise

[ API-Satz: ExcelApi 1.9 ]

patternTintAndShade

Stellt die format.fill.patternTintAndShade Eigenschaft dar.

patternTintAndShade?: number;

Eigenschaftswert

number

Hinweise

[ API-Satz: ExcelApi 1.9 ]

tintAndShade

Stellt die format.fill.tintAndShade Eigenschaft dar.

tintAndShade?: number;

Eigenschaftswert

number

Hinweise

[ API-Satz: ExcelApi 1.9 ]