XlsFile.Replace Method
Replaces the instances of oldValue by newValue in the active sheet, and allows to specify the cell format and value for every replaced cell.
Syntax
Namespace: FlexCel.XlsAdapter
public override Int32 Replace(Object oldValue, Object newValue, TXlsCellRange Range, Boolean CaseInsensitive, Boolean SearchInFormulas, Boolean WholeCellContents, Action<TReplaceAction> ReplaceAction)Parameters
| <-> | Parameter | Type | Description |
|---|---|---|---|
| oldValue | Object | Value we want to replace. | |
| newValue | Object | Value we want to use to replace oldValue. | |
| Range | TXlsCellRange | Range to Search. Null means the whole worksheet. | |
| CaseInsensitive | Boolean | If true, string searches will not be case sensitive, "a" = "A" | |
| SearchInFormulas | Boolean | If true, the search will cover formulas too. | |
| WholeCellContents | Boolean | If true, only whole cells will be replaced. | |
| ReplaceAction | Action<TReplaceAction> | Action to be performed in every replacement. |
Returns
The number of replacements done.
Examples
To replace all cells on a sheet that contain 1999-01-01 with 2003-01-01, formatting the cells in column 3 as blue:
xls.Replace(new DateTime(1999, 01, 01), new DateTime(2003, 01, 01), null, true, true, true,
(x) =>
{
if (x.Col == 3)
{
TFlxFormat fm = x.Workbook.GetFormat(x.XF);
fm.FillPattern.FgColor = Colors.Red;
fm.FillPattern.Pattern = TFlxPatternStyle.Solid;
x.XF = x.Workbook.AddFormat(fm);
}
}
);