Excel.CellPropertiesFill interface

Pacote:

excel

Representa as format.fill propriedades degetCellProperties ,getRowProperties e getColumnProperties ou o format.fill parâmetro de entrada de setCellProperties,setRowProperties e .setColumnProperties

Comentários

[ Conjunto de API: ExcelApi 1.9 ]

Propriedades

color	Representa a propriedade format.fill.color.
pattern	Representa a propriedade format.fill.pattern.
patternColor	Representa a propriedade format.fill.patternColor.
patternTintAndShade	Representa a propriedade format.fill.patternTintAndShade.
tintAndShade	Representa a propriedade format.fill.tintAndShade.

Detalhes da propriedade

color

Representa a propriedade format.fill.color.

color?: string;

Valor da propriedade

string

Comentários

[ Conjunto de API: ExcelApi 1.9 ]

Exemplos

// 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

Representa a propriedade format.fill.pattern.

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

Valor da propriedade

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

Comentários

[ Conjunto de API: ExcelApi 1.9 ]

patternColor

Representa a propriedade format.fill.patternColor.

patternColor?: string;

Valor da propriedade

string

Comentários

[ Conjunto de API: ExcelApi 1.9 ]

patternTintAndShade

Representa a propriedade format.fill.patternTintAndShade.

patternTintAndShade?: number;

Valor da propriedade

number

Comentários

[ Conjunto de API: ExcelApi 1.9 ]

tintAndShade

Representa a propriedade format.fill.tintAndShade.

tintAndShade?: number;

Valor da propriedade

number

Comentários

[ Conjunto de API: ExcelApi 1.9 ]