GrapeCity.Documents.Excel.ReplaceOptions.MatchCase

MatchCase Property

MatchCase

Gets or sets whether the search is case-sensitive.

This option controls whether Replace(object, object, ReplaceOptions) matches letter case when searching text. The default value is false.

Declaration

public bool MatchCase { get; set; }

Public Property MatchCase As Boolean

Examples

worksheet.Range["A1:A3"].Value = new object[,] {
    {"newyork"},
    {"NewYork"},
    {"NEWYORK"}
};
ReplaceOptions options = new ReplaceOptions();
options.MatchCase = true;
bool matchCase = options.MatchCase;
worksheet.Range["A1:A3"].Replace("newyork", "Seattle", options);