This basic tutorial explains how to unprotect Excel in C#. It covers the IDE configuration, stepwise algorithm, and a code snippet to unlock Excel file in C#. You only need to make a few API calls to complete this process or to improvise it to meet your requirements.
Steps to Unprotect Excel in C#
- Configure the IDE to use Aspose.Cells for .NET to unprotect Excel
- Create a Workbook class object to access the protected Excel file
- Remove the password security by invoking the Unprotect() method
- Save the output Excel workbook
These steps illustrate how to unlock Excel file in C# without needing to install MS Excel or any other user interface. First of all, access the secured XLS or XLSX file and remove its password. Subsequently, export the output file or manipulate it further depending on your workflow.
Code to Unprotect Excel File in C#
This sample code is efficient to develop Excel password remover in C#. However, you can further improvise it to unprotect a shared workbook too, if required. Similarly, the other properties and methods of the Workbook class can be used to work with themes, data connections, data sorters, etc. to process the output Excel file.
In this guide, we have understood how to remove password from Excel in C#. However, if you need to protect an Excel file with a password then refer to how to Password Protect an Excel file in C#.