An exception

Aspose.Cells Product Family
1

Hi,

I have an excel doc which is not protected, but when I am trying to do open() on it getting the following error:
ex.Message “Currently, Worksheets protected by password is not supported.” String

What is wrong?

Excel or sofartisans product work fine with this file.

Thanks
Mark

2

Dear Mark,

Could you send your excel doc to me? I will investigate this problem as soon as possible.

3

@mark,
Aspose.Excel is replaced with Aspose.Cells which is much more efficient and supports all the features in the latest versions of MS Excel as well. You can now process the password protected files as demonstrated in the following example:

// Create an instance of Workbook and load a spreadsheet
var book = new Workbook(dataDir + "Sample.xlsx");

// Access the protected Worksheet
var sheet = book.Worksheets[0];

// Check if Worksheet is password protected
if (sheet.Protection.IsProtectedWithPassword)
{
    // Verify the password used to protect the Worksheet
    if (sheet.Protection.VerifyPassword("1234"))
    {
        Console.WriteLine("Specified password has matched");
    }
    else
    {
        Console.WriteLine("Specified password has not matched");
    }
}

For more details have a look at the following article:
Verify Password Used to Protect the Worksheet
Detect if Worksheet is Password Protected
Check Password to modify using Aspose.Cells
Unprotect a Worksheet

Download the latest version of Aspose.Cells for .NET from the following link:
Aspose.Cells for .NET (Latest Version)

You can download the latest demos here.