This section aims at providing developers a solution to unlock sheet in Excel workbook with C#, VB.NET via this Excel library Spire.XLS for .NET.
Spire.XLS for .NET enables you to unlock any sheet in Excel file only by one line of key code: Spire.Xls.Worksheet.Unprotect(string password); Besides, as an MS Excel component, Spire.XLS for .NET also enables you to create, read and handle Excel files with fast speed. Below is an Excel file with protected worksheets which will be unlocked in my task.
Since you will use Spire.XLS for .NET, you have to download Spire.XLS for .NET and install it on system. When you create your project, please do not forget to add Spire.XLS.dll as reference from Bin folder. The default path is "..\Spire.XLS\Bin\NET4.0\Spire.XLS.dll". Please note that Spire.XLS for .NET supports .NET Framework 2.0 and above. Here is the whole code for unlocking Excel sheet:
namespace UnlockExcelSheet
{
class Program
{
static void Main(string[] args)
{
//initialize an instance of Workbook
Workbook workbook = new Workbook();
//Load an Excel file with protected worksheet
workbook.LoadFromFile(@"..\Unlock Excel Worksheet.xlsx");
//get the first worksheet
Worksheet sheet = workbook.Worksheets[0];
//Unprotect worksheet
sheet.Unprotect("iceblue");
//Save the file
workbook.SaveToFile("Sample.xlsx",ExcelVersion.Version2010);
//Launch the file
System.Diagnostics.Process.Start("Sample.xlsx");
}
}
}
Namespace UnlockExcelSheet
Class Program
Private Shared Sub Main(args As String())
'initialize an instance of Workbook
Dim workbook As New Workbook()
'Load an Excel file with protected worksheet
workbook.LoadFromFile("..\Unlock Excel Worksheet.xlsx")
'get the first worksheet
Dim sheet As Worksheet = workbook.Worksheets(0)
'Unprotect worksheet
sheet.Unprotect("iceblue")
'Save the file
workbook.SaveToFile("Sample.xlsx",ExcelVersion.Version2010)
'Launch the file
System.Diagnostics.Process.Start("Sample.xlsx")
End Sub
End Class
End Namespace
After executing above code, you can see that the protected worksheet in the original Excel file has been unlocked, we can edit it also. Please see following image.
In this section, I have introduced the solution to unlock any sheet in Excel file via Spire.XLS for .NET. I hope it can help you. If you have any questions, feedbacks and advice, you can put them on E-iceblue Forum. We will promise a prompt reply.
