CellColumnRedaction class Leave feedback
On this page
Represents a text redaction that replaces text in a spreadsheet document (CSV, Excel, etc.).
- Learn more: https://docs.groupdocs.com/redaction/net/redaction-basics/
- More details about spreadsheet redactions: https://docs.groupdocs.com/redaction/net/spreadsheet-redactions/
The CellColumnRedaction type exposes the following members:
| Constructor | Description |
|---|---|
| init | Initializes a new CellColumnRedaction. |
| Method | Description |
|---|---|
| apply_to | Applies the redaction to a given format instance. |
| apply_to_document_format_instance |
| Property | Description |
|---|---|
| description | The description of the redaction, containing its name and parameters. |
| filter | The column and worksheet filter. |
| pattern | The regular expression pattern to match. |
| action_options | The ReplacementOptions instance specifying the type of text replacement. (inherited from TextRedaction) |
| ocr_connector | The IOcrConnector implementation used to extract text from graphic content. (inherited from TextRedaction) |
from groupdocs.redaction import Redactor
from groupdocs.redaction.redactions import CellColumnRedaction, ReplacementOptions
from groupdocs.redaction.filters import CellFilter
with Redactor("Sales in September.xlsx") as redactor:
filter = CellFilter(column_index=1, worksheet_name="Customers")
regex = r"^\w+([-+.']\w+)*@\w+([-.]\w+)*\.\w+([-.]\w+)*$"
redactor.apply(CellColumnRedaction(filter, regex, ReplacementOptions("[customer email]")))
redactor.save()
Was this page helpful?
Any additional feedback you'd like to share with us?
Please tell us how we can improve this page.
Thank you for your feedback!
We value your opinion. Your feedback will help us improve our documentation.
