What You Can Do with GroupDocs.Redaction for Python via .NET

Find and Remove Private Text in EXCEL Files with Python

Use Python and GroupDocs.Redaction for Python via .NET to clear sensitive details from your EXCEL documents. Whether it’s for work or personal use, your content stays safe.

PyPI Download

Start Free Trial

How to Redact Text in Excel Files

With GroupDocs.Redaction for Python via .NET in your Python via .NET projects, you can easily remove or hide private content.

Create a Redactor and open your Excel file.
Choose your redaction settings.
Enter the text you want to search and what to replace it with.
Run the redaction and save your updated file.

Sample redactions Copy

import groupdocs.redaction as gr
import groupdocs.redaction.redactions as grr

# How to redact text in a EXCEL file

# Set up your redaction options
# Choose the text to search and what to replace it with
repl_opt = grr.ReplacementOptions("[redacted]")
        
redaction = grr.ExactPhraseRedaction("Text to hide", repl_opt)

# Open your file with the Redactor constructor
with gr.Redactor("input.xslx") as redactor:

    # Apply the redactions and save your new EXCEL file
    result = redactor.apply(redaction)
    redactor.save()

pip install groupdocs-redaction-net

click to copy

copied

More Redaction Features

GroupDocs.Redaction for Python via .NET helps you clear sensitive content across many file formats. Keep your documents safe and shareable.

Replace private text

Search and replace any matching text. Works with smart search and regex patterns.

Cover image content

Hide parts of images with overlays. Customize how it looks on the page.

Remove hidden details

Erase metadata like author info, comments, and timestamps.

Redact Patterns with Regex

Use regex to find and clean text patterns like emails, phone numbers, or account details.

Python

Download result Copy

import groupdocs.redaction as gr
import groupdocs.redaction.options as gro
import groupdocs.redaction.redactions as grr

# Define your EMAIL regex pattern and replacement text
repl_opt = grr.ReplacementOptions(color)
emailRegex = "[a-zA-Z0-9._%+-]+@[a-zA-Z0-9.-]+\.[a-zA-Z]{2,}"

redaction = grr.RegexRedaction(emailRegex, repl_opt)

# Open the file you need to clean
with gr.Redactor("source.xslx") as redactor:

    # Apply redaction rules
    result = redactor.apply(redaction)

    # Save the final version of the file
    so = gro.SaveOptions()
    so.add_suffix = True
    so.rasterize_to_pdf = False
    result_path = redactor.save(so)

pip install groupdocs-redaction-net

click to copy

copied

Meet GroupDocs.Redaction for Python via .NET

GroupDocs.Redaction for Python via .NET gives Python developers everything they need to clean up EXCEL files. Remove text, images, comments, and metadata with simple code.

Learn more