NativeExcel for .Net Developer's Reference

ICharacters.InsertMethod

Inserts a string preceding the specified Characters.

[Visual Basic]
SubInsert(_
ByValValueAsString_
)
[C#]
voidInsert(
stringValue
);
[C++]
voidInsert(
String*Value
);
[JScript]
functionInsert(
StringValue
);

Parameters

Value
The string to insert

Example

This example appends text at the end of B10 cell

[C#]
ICharacters c = book.Worksheets[1].Range["B10"].Characters;
c[c.Count + 1, 0].Insert("text"); 
[VisualBasic]
Dim c As ICharacters = book.Worksheets(1).Range("B10").Characters
c(c.Count + 1, 0).Insert("text") 
[C++]
ICharacters* c = book->Worksheets->Item[1]->Range->Item[S"B10"]->Characters;
c->Item[c->Count + 1, 0]->Insert(S"text");

See Also

ICharacters Interface | NativeExcel Namespace