Is there a way to change the color of a line shape in an Office.js Excel add in?

user_13624278 0
Viewed 253

I have tried the shape.fill.setSolidColor("color"); method as well as fill.setForegroundColor = 'color'; property. Neither of these seems to work and at times throw errors. Can a line shape be changed from its default blue color in excel add-ins? Much appreciated.

excel-addins office-js excel javascript
1 Answers

Welcome to Office JS world, Yes, the line shape color can be changed by Shape.lineFormat API. You may try the following sample code in the script lab

async function addStraightLine() {
  await Excel.run(async (context) => {
    const shapes = context.workbook.worksheets.getItem("Shapes").shapes;
    const line = shapes.addLine(200, 50, 300, 150, Excel.ConnectorType.straight);
    line.lineFormat.color = "red";
    line.name = "StraightLine";
    await context.sync();
  });
}

Reference document can be found https://docs.microsoft.com/en-us/javascript/api/excel/excel.shapelineformat?view=excel-js-preview

user_110894110
Related