Excel.CellPropertiesFill interface

Paket:

excel

Stellt die format.fill Eigenschaften von getCellProperties,getRowProperties , undgetColumnProperties/oder den format.fill Eingabeparameter von setCellProperties, setRowProperties, und setColumnPropertiesdar.

Hinweise

API-Satz: ExcelApi 1.9

Verwendet von

• Excel.CellPropertiesFormat: fill

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

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

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