Spreadsheet redactions Leave feedback
On this page
GroupDocs.Redaction allows to redact data of sensitive or private nature from your XLS, XLSX, ODS spreadsheet document formats and others. See full list at supported document formats article.
from groupdocs.redaction import Redactor
from groupdocs.redaction.options import SaveOptions
from groupdocs.redaction.redactions import ExactPhraseRedaction, ReplacementOptions
def redact_spreadsheet_content():
# Specify the redaction options
repl_opt = ReplacementOptions("-redacted-")
ex_red = ExactPhraseRedaction("John Doe", repl_opt)
# Load the spreadsheet to be redacted
with Redactor("./sample.xlsx") as redactor:
# Apply the redaction
result = redactor.apply(ex_red)
# Save the redacted document next to the source file
so = SaveOptions()
so.add_suffix = True
so.rasterize_to_pdf = False
so.redacted_file_suffix = "redacted"
redactor.save(so)
if __name__ == "__main__":
redact_spreadsheet_content()
sample.xlsx is the sample file used in this example. Click here to download it.
Binary file (XLSX, 15 KB)
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.
