TRY NEW VERSION

Try now New API BETA

Try out the new view and capabilities of the API documentation

START

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.

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();

Resulting document