How to Set a Password to Workbook

// This code demonstrates working with the IronXL library to open, modify, and secure Excel workbooks.
// Make sure to have the IronXL library installed and properly referenced in your project.

using IronXL;

// Load a workbook from the specified file. 
// Note: The file "sample.xlsx" should exist in the working directory.
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Load a password-protected workbook by providing the password "IronSoftware".
// Useful in scenarios where access to the contents of the workbook is restricted.
WorkBook protectedWorkBook = WorkBook.Load("sample.xlsx", "IronSoftware");

// Encrypt the previously loaded workbook with a specified password.
// This ensures that unauthorized users cannot open the file without the password "IronSoftware".
workBook.Encrypt("IronSoftware");

// Save any changes made to the workbook back to the original file.
// This step is crucial, especially after encrypting, to ensure protection settings are applied.
workBook.Save();

' This code demonstrates working with the IronXL library to open, modify, and secure Excel workbooks.

' Make sure to have the IronXL library installed and properly referenced in your project.



Imports IronXL



' Load a workbook from the specified file. 

' Note: The file "sample.xlsx" should exist in the working directory.

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



' Load a password-protected workbook by providing the password "IronSoftware".

' Useful in scenarios where access to the contents of the workbook is restricted.

Private protectedWorkBook As WorkBook = WorkBook.Load("sample.xlsx", "IronSoftware")



' Encrypt the previously loaded workbook with a specified password.

' This ensures that unauthorized users cannot open the file without the password "IronSoftware".

workBook.Encrypt("IronSoftware")



' Save any changes made to the workbook back to the original file.

' This step is crucial, especially after encrypting, to ensure protection settings are applied.

workBook.Save()

// This line of code is used to remove the password protection from a given workbook.
// In order to reset the password, the original password must be provided initially.

// The code assumes `workBook` is an instance of a valid object of a class that represents a workbook.
// The `Password` is a property of `workBook` used to manage the password protection status of the workbook.
workBook.Password = null;

// Note: Ensure that any necessary validation or unlocking 
// procedures for the workbook have been handled earlier in the code pipeline for this operation to succeed.

' This line of code is used to remove the password protection from a given workbook.

' In order to reset the password, the original password must be provided initially.



' The code assumes `workBook` is an instance of a valid object of a class that represents a workbook.

' The `Password` is a property of `workBook` used to manage the password protection status of the workbook.

workBook.Password = Nothing



' Note: Ensure that any necessary validation or unlocking 

' procedures for the workbook have been handled earlier in the code pipeline for this operation to succeed.