Replace text in a workbook using Regular Expression

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

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

Sample Code