Replace text in a workbook using Regular Expression

Aspose.Cells provides the feature to replace text in a workbook using a regular expression. For this, the API provides RegexKey property of the ReplaceOptions class. Setting the RegexKey to true indicates that the searched key will be a regular expression.

The following code snippet demonstrates the use of the RegexKey property by using the sample excel file. The output file generated by the following code snippet is attached for reference.

Sample Code

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-Java
// directories
String sourceDir = Utils.Get_SourceDirectory();
String outputDir = Utils.Get_OutputDirectory();

Workbook workbook = new Workbook(sourceDir + "SampleRegexReplace.xlsx");

ReplaceOptions replace = new ReplaceOptions();
replace.setCaseSensitive(false);
replace.setMatchEntireCellContents(false);
// Set to true to indicate that the searched key is regex
replace.setRegexKey(true);

workbook.replace("\\bKIM\\b", "^^^TIM^^^", replace);
workbook.save(outputDir + "RegexReplace_out.xlsx");