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

Giving information or data to the correct individual is very important in conveying a correct authority. IronXL makes it possible to create password protected spreadsheet as well as each individual WorkSheet.

Accessing

Protected spreadsheet can be opened by providing password as the second parameter to Load method. For example, WorkBook.Load("sample.xlsx", "IronSoftware").

Applying

Use Encrypt method to password protect any spreadsheet. For example, workBook.Encrypt("IronSoftware").

Removing

Removing password from spreadsheet is as simple as setting null to Password field as demonstrated workBook.Password = null. This action can only be done after accessing the workbook. Hence, knowing the original password is a must.

IronXL allows you to Protect and Unprotect any Excel WorkBook and WorkSheet with a single line of C# code.