replace_in_column method

replace_in_column

Replaces all matches with a given replacement in the specified column and worksheet.

def replace_in_column(self, regular_expression, replacement, column, sheet):
    ...
Parameter Type Description
regular_expression System.Text.RegularExpressions.Regex Regular expression to search and replace.
replacement str Textual replacement.
column int Zero-based column index.
sheet int Zero-based worksheet index.

Returns: Replacement result.

replace_in_column

Replaces all matches with a given replacement in the specified column on all worksheets.

def replace_in_column(self, regular_expression, replacement, column):
    ...
Parameter Type Description
regular_expression System.Text.RegularExpressions.Regex Regular expression to search and replace.
replacement str Textual replacement.
column int Zero-based column index.

Returns: Replacement result.

See Also