Excel Decryption for XLS in C# and VB.NET

XLS decryption enables you to read files that are encrypted with a password. To read a protected or encrypted Excel workbook, you'll need to provide a XlsLoadOptions.Password value.

Note that GemBox.Spreadsheet currently doesn't support encrypting XLS files (saving password protected XLS files), but it does support encrypting XLSX files.

The following example shows how to load an encrypted XLS file and save it as a decrypted XLS file in C# and VB.NET.

Decrypting Excel file of XLS format in C# and VB.NET
Screenshot of Excel workbook's decryption
Upload your file (Drag file here)
View on GitHub 
using GemBox.Spreadsheet;

class Program
{
    static void Main()
    {
        // If using the Professional version, put your serial key below.
        SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");

        var inputPassword = "%InputPassword%";

        var workbook = ExcelFile.Load("%InputFileName%",
            new XlsLoadOptions() { Password = inputPassword });

        workbook.Save("Decrypted File.xls");
    }
}
Imports GemBox.Spreadsheet

Module Program

    Sub Main()

        ' If using the Professional version, put your serial key below.
        SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY")

        Dim inputPassword = "%InputPassword%"

        Dim workbook = ExcelFile.Load("%InputFileName%",
            New XlsLoadOptions With {.Password = inputPassword})

        workbook.Save("Decrypted File.xls")

    End Sub
End Module

See also

Excel worksheet protection | GemBox.Spreadsheet Example

Excel worksheet protection | GemBox.Spreadsheet Example

Next steps

GemBox.Spreadsheet is a .NET component that enables you to read, write, edit, convert, and print spreadsheet files from your .NET applications using one simple API.

Download Buy
Published: December 18, 2020 | Modified: December 19, 2022 | Author: Marek Turis