Note

Access to this page requires authorization. You can try signing in or .

Access to this page requires authorization. You can try .

Excel.ShapeLineStyle enum

Package:
excel

The style for a line.

Remarks

API set: ExcelApi 1.9

Used by

Examples

// Link to full sample: https://raw.githubusercontent.com/OfficeDev/office-js-snippets/prod/samples/excel/44-shape/shape-fill-and-line-formatting.yaml

await Excel.run(async (context) => {
 // Apply outline formatting to the shape.
 const sheet = context.workbook.worksheets.getItem("Sample");
 const badge = sheet.shapes.getItem("Badge");
 const lineFormat: Excel.ShapeLineFormat = badge.lineFormat;
 lineFormat.set({
 color: "#C55A11",
 dashStyle: Excel.ShapeLineDashStyle.dashDotDot,
 style: Excel.ShapeLineStyle.thinThick,
 transparency: 0.2,
 visible: true,
 weight: 4
 });

 await context.sync();
});

Fields

single = "Single"

Single line.
thickBetweenThin = "ThickBetweenThin"

Thick line with a thin line on each side.
thickThin = "ThickThin"

Thick line next to thin line. For horizontal lines, the thick line is above the thin line. For vertical lines, the thick line is to the left of the thin line.
thinThick = "ThinThick"

Thick line next to thin line. For horizontal lines, the thick line is below the thin line. For vertical lines, the thick line is to the right of the thin line.
thinThin = "ThinThin"

Two thin lines.

Feedback

Was this page helpful?