Skip to main content

SetWidth

Sets the width to the current path.

Syntax

expression.SetWidth(nWidth);

expression - A variable that represents a ApiPath class.

Parameters

NameRequired/OptionalData typeDefaultDescription
nWidthRequirednumberThe path width in EMU.

Returns

This method doesn't return any data.

Example

Define the horizontal size of a custom shape path before adding it to a spreadsheet.

// How do I control how wide a custom shape path is in a spreadsheet?

// Assign a specific width to a drawn path so it scales correctly within the sheet in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let customGeometry = Api.CreateCustomGeometry();
let path = customGeometry.AddPath();
path.SetWidth(100 * 36000);
path.SetHeight(100 * 36000);
path.SetStroke(true);
path.SetFill("norm");
path.MoveTo(50 * 36000, 0);
path.LineTo(70 * 36000, 45 * 36000);
path.LineTo(55 * 36000, 70 * 36000);
path.LineTo(100 * 36000, 100 * 36000);
path.LineTo(0, 100 * 36000);
path.Close();
let fill = Api.CreateSolidFill(Api.RGB(100, 150, 200));
let stroke = Api.CreateStroke(18000, Api.CreateSolidFill(Api.RGB(50, 75, 100)));
let shape = worksheet.AddShape("rect", 60 * 36000, 60 * 36000, fill, stroke, 3, 0, 2, 2);
shape.SetGeometry(customGeometry);