Protect Excel Files

VB C#

using IronXL;

WorkBook workBook = WorkBook.Load("sample.xlsx");
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Open protected spreadsheet file
WorkBook protectedWorkBook = WorkBook.Load("sample.xlsx", "IronSoftware");

// Spreadsheet protection
// Set protection for spreadsheet file
workBook.Encrypt("IronSoftware");

// Remove protection for spreadsheet file. Original password is required.
workBook.Password = null;

workBook.Save();

// Worksheet protection
// Set protection for individual worksheet
workSheet.ProtectSheet("IronXL");

// Remove protection for particular worksheet. It works without password!
workSheet.UnprotectSheet();

workBook.Save();

Imports IronXL

Private workBook As WorkBook = WorkBook.Load("sample.xlsx")
Private workSheet As WorkSheet = workBook.DefaultWorkSheet

' Open protected spreadsheet file
Private protectedWorkBook As WorkBook = WorkBook.Load("sample.xlsx", "IronSoftware")

' Spreadsheet protection
' Set protection for spreadsheet file
workBook.Encrypt("IronSoftware")

' Remove protection for spreadsheet file. Original password is required.
workBook.Password = Nothing

workBook.Save()

' Worksheet protection
' Set protection for individual worksheet
workSheet.ProtectSheet("IronXL")

' Remove protection for particular worksheet. It works without password!
workSheet.UnprotectSheet()

workBook.Save()

Install-Package IronXL.Excel

Protect Excel Files

The Encrypt method of IronXL provides developers with the ability to apply password protection for both entire Excel workbooks and individual worksheets. This capability is crucial for safeguarding sensitive data and ensuring that only authorized users can access or modify the contents of an Excel file.

IronXL also allows for sheet-level protection, which can prevent users from editing certain parts of the workbook or specific worksheets. This is particularly useful in collaborative environments where you want to restrict editing rights but still allow users to view or interact with data. Additionally, the option to remove protection with or without a password offers flexibility, making it suitable for both secure environments and situations where access needs to be temporarily restored. Overall, this feature is an essential tool for ensuring Excel file security in automated data processing workflows.

5 steps to Encrypt a Workbook with Password

var workBook = WorkBook.Load("sample.xlsx");
workBook.Encrypt("myP@ssw0rd");
var workSheet = workBook.DefaultWorkSheet;
workSheet.ProtectSheet("myP@ssw0rd_sheet");
workBook.Save();

// Load the workbook from an existing Excel file.
var workBook = WorkBook.Load("sample.xlsx");

// Apply password protection to the entire workbook.
workBook.Encrypt("myP@ssw0rd");

// Access the default worksheet from the workbook.
var workSheet = workBook.DefaultWorkSheet;

// Protect the worksheet with a password to prevent editing.
workSheet.ProtectSheet("myP@ssw0rd_sheet");

// Save the changes made to the workbook and its worksheets.
workBook.Save();

// Load the workbook from an existing Excel file.
var workBook = WorkBook.Load("sample.xlsx");

// Apply password protection to the entire workbook.
workBook.Encrypt("myP@ssw0rd");

// Access the default worksheet from the workbook.
var workSheet = workBook.DefaultWorkSheet;

// Protect the worksheet with a password to prevent editing.
workSheet.ProtectSheet("myP@ssw0rd_sheet");

// Save the changes made to the workbook and its worksheets.
workBook.Save();

' Load the workbook from an existing Excel file.
Dim workBook = WorkBook.Load("sample.xlsx")

' Apply password protection to the entire workbook.
workBook.Encrypt("myP@ssw0rd")

' Access the default worksheet from the workbook.
Dim workSheet = workBook.DefaultWorkSheet

' Protect the worksheet with a password to prevent editing.
workSheet.ProtectSheet("myP@ssw0rd_sheet")

' Save the changes made to the workbook and its worksheets.
workBook.Save()

$vbLabelText $csharpLabel

In this code, a workbook is first loaded from the file sample.xlsx using IronXL's WorkBook.Load() method. After the workbook is loaded, the Encrypt() method is used to apply password protection to the entire workbook, with the password set as myP@ssw0rd. This ensures that the workbook cannot be opened or modified without the correct password.

Next, the default worksheet of the workbook is accessed using the DefaultWorkSheet property. The ProtectSheet() method is then called on this worksheet, applying a password ("myP@ssw0rd_sheet") that restricts editing on the sheet level. This prevents users from making changes to the protected sheet unless they provide the correct password.

Finally, the Save() method is invoked to save the changes made to both the workbook and the worksheet, ensuring that the protection settings are preserved in the saved file. This ensures that the workbook and its worksheet are both securely protected and can only be accessed or modified with the respective passwords.

Click here to view the How-to Guide, including examples, sample code, and files