Protection of Excel Spreadsheets by Adding, Removing, and Changing Password using C#

readme.md

Related Article(s):

• C# - Lock and Unlock Excel Files with Password
• Password Protect Excel Spreadsheets
• Unlock Password Protected Excel Spreadsheets

ChangeSpreadsheetPassword.cs

/*
 * Change password of protected Excel spreadsheets using C#
 */
string filePath = @"path/protected-spreadsheet.xlsx";

LoadOptions loadOptions = new LoadOptions("mySECRETpassWORD");
UpdatePasswordOptions updateOptions = new UpdatePasswordOptions("TOPSECRET_pa22WORD");

using (Merger merger = new Merger(filePath, loadOptions))
{
    merger.UpdatePassword(updateOptions);
    merger.Save(@"path/pwd-changed-spreadsheet.xlsx");
}

PasswordProtectSpreadsheet.cs

/*
 * Add password protection to Excel spreadsheets files (XLS/XLSX) using C#
 */
string filePath = @"path/spreadsheet.xlsx";

AddPasswordOptions addOptions = new AddPasswordOptions("mySECRETpassWORD");

using (Merger merger = new Merger(filePath))
{
    merger.AddPassword(addOptions);
    merger.Save(@"path/protected-spreadsheet.xlsx");
}

RemoveSpreadsheetPassword.cs

/*
 * Remove password protection from Excel spreadsheets using C#
 */
string filePath = @"path/protected-spreadsheet.xlsx";

LoadOptions loadOptions = new LoadOptions("mySECRETpassWORD");

using (Merger merger = new Merger(filePath, loadOptions))
{
    merger.RemovePassword();
    merger.Save(@"path/unlocked-spreadsheet.xlsx");
}