CONCATENATE

CONCATENATE(arg_n) → { string }

Combines multiple text strings into one text string.

Parameters:

Name Type Description
arg_n string

Up to 255 data values that will be combined.

Returns:

Type
string

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.CONCATENATE("John", " ", "Adams"));
builder.SaveFile("xlsx", "CONCATENATE.xlsx");
builder.CloseFile();

Resulting document