SetUnderline

SetUnderline(undelineType)

Specifies that the contents of the current cell / cell range are displayed along with a line appearing directly below the character.

Parameters:

Name	Type	Description
undelineType	'none' \| 'single' \| 'singleAccounting' \| 'double' \| 'doubleAccounting'	Specifies the type of the line displayed under the characters. The following values are available: "none" - for no underlining; "single" - for a single line underlining the cell contents; "singleAccounting" - for a single line underlining the cell contents but not protruding beyond the cell borders; "double" - for a double line underlining the cell contents; "doubleAccounting" - for a double line underlining the cell contents but not protruding beyond the cell borders.

Name

Type

Description

undelineType

'none' | 'single' | 'singleAccounting' | 'double' | 'doubleAccounting'

Specifies the type of the line displayed under the characters. The following values are available:

"none" - for no underlining;
"single" - for a single line underlining the cell contents;
"singleAccounting" - for a single line underlining the cell contents but not protruding beyond the cell borders;
"double" - for a double line underlining the cell contents;
"doubleAccounting" - for a double line underlining the cell contents but not protruding beyond the cell borders.

Returns:

This method doesn't return any data.

Example

Copy code

builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
oWorksheet.GetRange("A2").SetValue("The text underlined with a single line");
oWorksheet.GetRange("A2").SetUnderline("single");
oWorksheet.GetRange("A4").SetValue("Normal text");
builder.SaveFile("xlsx", "SetUnderline.xlsx");
builder.CloseFile();

SetUnderline

SetUnderline(undelineType)

Parameters:

Returns:

Example

Resulting document

Get information

Get help