Returns an ICharacters interface that represents a subsequence of characters within the specified Characters object.

Overload List

Returns an ICharacters interface that represents a subsequence of characters within the specified Characters object. The subsequence starts at a specified character position.

[Visual Basic] Default Property ReadOnly Item(ByVal Integer) As ICharacters

[C#] ICharacters this[int] { get; }

[C++] __property ICharacters* get_Item(int);

Returns an ICharacters interface that represents a subsequence of characters within the specified Characters object. The subsequence starts at a specified character position and has a specified length.

[Visual Basic] Default Property ReadOnly Item(ByVal Integer,ByVal Integer) As ICharacters

[C#] ICharacters this[int,int] { get; }

[C++] __property ICharacters* get_Item(int,int);

Example

This example deletes substring from A1 cell value

[C#]
book.Worksheets[1].Range["A1"].Characters[3,4].Delete();

[Visual Basic]
book.Worksheets(1).Range("A1").Characters(3,4).Delete()

[C++]
book->Worksheets->Item[1]->Range->Item[S"A1"]->Characters->Item[3,4]->Delete();

This example gets the substring from A1 cell value.

[C#]
string txt = book.Worksheets[1].Range["A1"].Characters[3,5].Text;

[Visual Basic]
Dim txt As String = book.Worksheets(1).Range("A1").Characters(3,5).Text

[C++]
String* txt = book->Worksheets->Item[1]->Range->Item[S"A1"]->Characters->Item[3,5]->Text;

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

[Visual Basic]
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 | IRange.Characters Property | ICharacters.Count Property

---