What You Get with GroupDocs.Redaction for Python via .NET

Hide Text in XLSX Files Using Python Overlays

Protect sensitive text in your XLSX files with GroupDocs.Redaction for Python via .NET and Python by placing simple overlays.

PyPI Download

Start Free Trial

Protect Data in Xlsx Files

GroupDocs.Redaction for Python via .NET lets Python via .NET developers hide private info with just a few lines of code.

Start by creating a Redactor and load your Xlsx file.
Set the redaction options that work for your case.
Add the text pattern you want to hide and choose a color.
Run redaction and save your file.

Sample redactions Copy

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

# Hide private content in XLSX with overlays

# Set redaction preferences
# Choose text to cover and overlay color
color = grd.Color.from_argb(255, 220, 20, 60)
repl_opt = grr.ReplacementOptions(color)
        
redaction = grr.ExactPhraseRedaction("Text to hide", repl_opt)

# Use Redactor to load your file
with gr.Redactor("input.xslx") as redactor:

    # Redact and save the file
    result = redactor.apply(redaction)
    redactor.save()

pip install groupdocs-redaction-net

click to copy

copied

Helpful Redaction Tools

GroupDocs.Redaction for Python via .NET lets you hide or remove content from many file types. Keep personal or business info protected.

Find and Edit Text

Search for specific text and replace or hide it.

Cover Image Content

Draw overlays over pictures to block out private areas.

Remove Metadata

Clean up background info before sharing your files.

Hide Text Using Regex Patterns

This example shows how to find and hide content using regular expressions.

Python

Download result Copy

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

# Set your text pattern and overlay color
color = grd.Color.from_argb(255, 220, 20, 60)
repl_opt = grr.ReplacementOptions(color)

redaction = grr.RegexRedaction("\\d{2}\\s*\\d{2}[^\\d]*\\d{6}", repl_opt)

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

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

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