Skip to main content

Insert

Inserts a string replacing the specified characters.

Syntax

expression.Insert(String);

expression - A variable that represents a ApiCharacters class.

Parameters

NameRequired/OptionalData typeDefaultDescription
StringRequiredstringThe string to insert.

Returns

This method doesn't return any data.

Example

Insert a string replacing the specified characters in a spreadsheet.

// How to replace characters with a different string value in a spreadsheet.

// Change the characters to another string value in a spreadsheet.

let worksheet = Api.GetActiveSheet();
let range = worksheet.GetRange("B1");
range.SetValue("This is just a sample text.");
let characters = range.GetCharacters(23, 4);
characters.Insert("string");