How to Set Password to Worksheet

using IronXL;

// Load the Excel workbook
WorkBook workBook = WorkBook.Load("sample.xlsx");

// Get the default worksheet from the workbook
// The default worksheet is typically the first one in the workbook
WorkSheet workSheet = workBook.DefaultWorkSheet;

// Protect the default worksheet with a password
// This ensures that the worksheet cannot be modified without the password.
// Note: Use a strong password to ensure your worksheet is secure.
workSheet.ProtectSheet("IronXL");

// Save the changes to the workbook
// This writes the protection to the file system, making it persistent
workBook.Save();

Imports IronXL



' Load the Excel workbook

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



' Get the default worksheet from the workbook

' The default worksheet is typically the first one in the workbook

Private workSheet As WorkSheet = workBook.DefaultWorkSheet



' Protect the default worksheet with a password

' This ensures that the worksheet cannot be modified without the password.

' Note: Use a strong password to ensure your worksheet is secure.

workSheet.ProtectSheet("IronXL")



' Save the changes to the workbook

' This writes the protection to the file system, making it persistent

workBook.Save()

// The following line of code unprotects the worksheet without requiring a password.
//
// Note: This assumes that 'workSheet' is an instance of a worksheet object from a spreadsheet library
// such as EPPlus or another library that uses similar method calls.
//
// If the library you're using provides the Unprotect() method without parameters, 
// this will remove protection from 'workSheet' without needing a password,
// enabling you to modify the contents of the worksheet.

workSheet.Unprotect();

' The following line of code unprotects the worksheet without requiring a password.

'

' Note: This assumes that 'workSheet' is an instance of a worksheet object from a spreadsheet library

' such as EPPlus or another library that uses similar method calls.

'

' If the library you're using provides the Unprotect() method without parameters, 

' this will remove protection from 'workSheet' without needing a password,

' enabling you to modify the contents of the worksheet.



workSheet.Unprotect()