HTML
JPG
PDF
XML
XLSM
XLSM
Unlock XLSM Spreadsheet via C#
Remove protection from XLSM using .NET library.
Aspose.Cells for .NET
Overview
How to Unlock XLSM File Using C#
In order to remove protection XLSM file, we’ll use
API which is a feature-rich, powerful and easy to use document protection API for C# platform. Open
package manager, search for Aspose.Cells and install. You may also use the following command from the Package Manager Console.
Aspose.Cells
PM> Install-Package Aspose.Cells
Unlock XLSM via C#
You need
referenced in your project to execute the following workflow.
- Instantiate Workbook class with path to protected XLSM file
- Get the default or any Worksheet to remove protection
- Remove Worksheet protection with Worksheet.Unprotect method
- Remove Workbook protection with Workbook.Unprotect method
- Save result in XLSM format
System Requirements
Aspose.Cells for .NET is supported on all major operating systems. Just make sure that you have the following prerequisites.
- Microsoft Windows or a compatible OS with .NET Framework, .NET Core, Mono or Xamarin Platforms
- Development environment like Microsoft Visual Studio
- Add reference to the Aspose.Cells for .NET DLL in your project
Command
// instantiate a Workbook object with protected XLSM file
var workbook = new Aspose.Cells.Workbook("protected.xlsm");
// access the default worksheet in the Excel file
var worksheet = workbook.Worksheets[0];
// unprotect worksheet without a password
worksheet.Unprotect();
// unprotect workbook with password
workbook.Unprotect("password");
// save the result back in XLSM format
workbook.Save("unprotected.xlsm", Aspose.Cells.SaveFormat.Auto);