Python 保护 Excel （开发者教程）

Features of IronXL

IronXL is a flexible and strong tool for working with Excel files in Python because of its many capabilities. Here are some of its most prominent characteristics:

• Reading and Writing Excel Files: IronXL enables smooth interaction with Excel-based workflows by allowing users to read data from existing Excel files and write data to new or existing Excel files.
• Support for Excel Formats: IronXL is compatible with a large number of Excel files and supports many Excel formats, including .xls and .xlsx.
• Cell-Level Manipulation: Within Excel files, users can read, set, format, lock specific cells, and perform other operations on individual cells.
• Formula Support: IronXL has support for Excel formulas, so users can do computations, automate data processing activities, and set and evaluate formulas within Excel files.
• Worksheet and Workbook Operations: Users can add, remove, rename, copy, and immediately access the first worksheet sheet among other operations on worksheets and workbooks.
• Data Validation: To guarantee data accuracy and integrity, IronXL supports data validation. Users can set data validation rules for individual cells and ranges within Excel files.
• Chart Generation: Using IronXL, users may build and edit charts inside Excel files, allowing data to be visualized for analysis and presentation.
• Data Encryption: To safeguard sensitive information from unwanted access or exposure, IronXL includes tools for encrypting Excel files. This adds an extra layer of protection.
• Excel files can be password-protected, preventing unauthorized users from opening, altering, or accessing the contents of the protected files.

IronXL is a useful tool for data manipulation, data analysis, reporting, and automation activities since it offers a wide range of tools and functionalities for working with Excel files in Python. IronXL provides the tools required to work effectively with Excel files in Python, whether you're a developer, data analyst, or business user. To learn more about the documentation, please refer here.

IronXL: Empowering Python for Excel Security

IronXL allows for a variety of actions on Excel files, bridging the gap between Python and Excel. This is how IronXL enhances a password-protected Excel file and security by enabling Python:

• Scripting Automation: You can create Python scripts using IronXL to automate security-related processes. Consider a script that logs the process, iterates over every Excel file in a folder, and imposes password security. This lowers human error and does away with manual intervention.
• Conditional Security: IronXL makes it easier to build conditional security. Python code that meets predetermined requirements and implements security measures following it can be written. For example, your script may password-protect a worksheet that contains private financial information automatically when it is saved.
• Granular Control: When compared to manual techniques, IronXL provides greater granular control over Excel security features. Python code can be used to create unique validation criteria, specify cell ranges to lock, and adjust password difficulty for better security.

Prerequisites

Before starting the guide, make sure the following are installed on your computer:

• As IronXL was created using the.NET 6.0 SDK, your machine must have it installed.
• Python 3.0+: You must have Python 3.0 or a later version installed to follow the examples in this article.
• pip: Since IronXL is dependent on it, install the Python package installer pip first.

Create a New file and Install IronXL

Launch Visual Studio Code, open this file, and then make a ProtectExcelFile.py Python file. Our script for Protect Excel files with IronXL is the function contained in this file.

Select Terminal > New Terminal from the menu to open and modify commands on the command line in Visual Studio Code.

The first thing to do before using IronXL is to learn how to install the library. The following line will swiftly install IronXL using pip, the default Python package manager:

pip install ironxl

pip install ironxl

IronXL may now be the method used to safeguard Excel spreadsheet files.

Password Protecting Excel Files

This article is a sample of Python code that shows how to use IronXL to password-protect an existing Excel file:

from ironxl import Workbook

# Specify file paths and password
file_path = "output.xlsx"
password = "test"

# Load the workbook
workbook = Workbook.load(file_path)

# Set document password
workbook.Password = password

# Save the protected workbook
workbook.save()

print("File password protected successfully!")

from ironxl import Workbook

# Specify file paths and password
file_path = "output.xlsx"
password = "test"

# Load the workbook
workbook = Workbook.load(file_path)

# Set document password
workbook.Password = password

# Save the protected workbook
workbook.save()

print("File password protected successfully!")

The Workbook class is imported from IronXL by this code. This script specifies the file path and password, loads the workbook, sets a password, and then saves the protected file. For the best security practices, use your actual input file path instead of "output.xlsx" and select a strong password.

Password Protecting Worksheets

Although IronXL can not provide password protection on a specific Excel worksheet, you can accomplish a comparable result by limiting editing but permitting searching and viewing. The following code depicts this example:

from ironxl import *

# Load an existing Excel file
workbook = WorkBook.Load("modified_data.xlsx")

# Access a specific worksheet
worksheet = workbook.WorkSheets[0]

# Get the cell
cell = worksheet["B2"]

# Set the background color of the cell with an RGB string
cell.Style.SetBackgroundColor("#428D65")

# Protect the worksheet with a password
worksheet.ProtectSheet("test")

# Save the workbook
workbook.Save()

from ironxl import *

# Load an existing Excel file
workbook = WorkBook.Load("modified_data.xlsx")

# Access a specific worksheet
worksheet = workbook.WorkSheets[0]

# Get the cell
cell = worksheet["B2"]

# Set the background color of the cell with an RGB string
cell.Style.SetBackgroundColor("#428D65")

# Protect the worksheet with a password
worksheet.ProtectSheet("test")

# Save the workbook
workbook.Save()

This script loads an Excel workbook, accesses a worksheet, and sets a password to protect the worksheet from editing by using the ProtectSheet method. Use your actual file path and name instead of "modified_data.xlsx" and choose a strong password for optimal security.

To learn more about the code, please refer here.