HTML
JPG
PDF
XML
XLSM
XLSM
Encrypt XLSM Files via C#
Password-protect Excel spreadsheets including XLSM format using .NET Library.
Aspose.Cells for .NET
Overview
How to Protect XLSM File Using C#
In order to protect 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
Protect XLSM via C#
You need
referenced in your project to execute the following workflow.
- Instantiate Workbook class with path to XLSM file
- Get the default or any Worksheet to add protection
- Protect Worksheet with Worksheet.Protect method
- Protect Workbook with Workbook.Protect 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
// load the XLSM Excel file
var book = new Aspose.Cells.Workbook("unlocked.xlsm");
// access the first worksheet
var worksheet = book.Worksheets[0];
// protect the worksheet with password
worksheet.Protect(Aspose.Cells.ProtectionType.All, "password", null);
// protect the whole workbook with password
book.Protect(Aspose.Cells.ProtectionType.All, "password");
// save the modified file in default format
book.Save("protected.xlsm");