Spire.XLS API

Spire.XLS namespace

Spire.Xls.Core.Spreadsheet

XlsRange Class

XlsRange Methods

Activate Method

AddCombinedRange Method

AddComment Method

ApplyStyle Method

AutoFitColumns Method

CalculateAllValue Method

CheckRange Method

Clear Method

ClearAll Method

ClearConditionalFormats Method

ClearContents Method

Clone Method

CollapseGroup Method

ConvertToNumber Method

CopyToClipboard Method

Dispose Method

ExpandGroup Method

ExportDataTable Method

GetConditionFormatsStyle Method

GetEnumerator Method

GetNamedRange Method

GetNewRangeLocation Method

GetRectangles Method

GetRectanglesCount Method

GroupByColumns Method

GroupByRows Method

InfillCells Method

InsertOrUpdateCellImage Method

RemoveCellImage Method

RemoveCombinedRange Method

RemoveMergeComment Method

ReparseFormulaString Method

Replace Method

SetAutoFormat Method

SetBorderToSingleCell Method

SetDataValidation Method

SetExtendedFormatIndex Method

SetRowHeight Method

SetSharedFormula Method

TextPartReplace Method

UngroupByColumns Method

XlsRange TextPartReplace Method

Replaces cell's part text and reserve text's format.

Namespace: Spire.Xls.Core.Spreadsheet
Assembly: Spire.XLS (in Spire.XLS.dll) Version: 15.4.0.0 (15.4.0.5046)

Syntax

C++

ASP.NET

Copy

public void TextPartReplace(
	string oldPartValue,
	string newPartValue
)

Public Sub TextPartReplace ( 
	oldPartValue As String,
	newPartValue As String
)

public:
void TextPartReplace(
	String^ oldPartValue, 
	String^ newPartValue
)

member TextPartReplace : 
oldPartValue : string * 
newPartValue : string -> unit

Parameters

oldPartValue: Type: System String
Part value of cell's text to search for.
newPartValue: Type: System String
The replacement value.

Reference

XlsRange Class

Spire.Xls.Core.Spreadsheet Namespace

XlsRange AddLanguageSpecificTextSet("LST9EC4FE2D_0?cpp=::|nu=."); TextPartReplace Method

Parameters

Reference

XlsRange TextPartReplace Method