SetColumnWidth

SetColumnWidth(nColumn, nWidth, [bWithotPaddings])

Sets the width of the specified column. One unit of column width is equal to the width of one character in the Normal style. For proportional fonts, the width of the character 0 (zero) is used.

Parameters:

Name Type Default Description
nColumn number

The number of the column to set the width to.

nWidth number

The width of the column divided by 7 pixels.

bWithotPaddings boolean false

Specifies whether nWidth will be set without standard paddings.

Returns:

This method doesn't return any data.

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
oWorksheet.SetColumnWidth(0, 10);
oWorksheet.SetColumnWidth(1, 20, true);
builder.SaveFile("xlsx", "SetColumnWidth.xlsx");
builder.CloseFile();

Resulting document