String concatenation operators.(Microsoft Excel Office Scripts)

kohki08

1 year ago

This section introduces the use of string concatenation operators in Office scripts.

Operations

In VBA macros, I used "+" or "&" to join strings,Office scripts use only "+".

function main(workbook: ExcelScript.Workbook) {
  let s1: string = "ABC";
  let s2: string = "ABC";
  let s3: string = "";

  s3 = s1 + s2;

  workbook.getWorksheet("Test").getRange("A2").setValue(s1);
}

To combine numbers as strings, use the toString() method to convert numbers to strings.

numeric.toString()

function main(workbook: ExcelScript.Workbook) {
  let n1: Number = 123;
  let n2: Number = 456;
  let s: string = "";

  s = n1.toString() + n2.toString();

  workbook.getWorksheet("Test").getRange("A2").setValue(s);
}