Replace text in a workbook using Regular Expression

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

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

Sample Code