Feature Request: Workbook.IsPasswordProtected(Stream stream)

[GerhardFinee]

Hi,

could you please consider adding a new overload of Workbook.IsPasswordProtected(Stream stream)?
Alternatively, it would also be great if there would be an appropriate error message when opening a password-protected sheet with the wrong password (or not password at all).

KR,
Gerhard

[Annika.Zhou]

Hello,

Thanks for your inquiry.
We will add an overload to accept a stream in IsPasswordProtected method. Once it is achieved in the future, we will let you know.
In addition, when Spire.XLS loads a password-protected Excel file, if the password is not used or the wrong password is used, the program will report an error "Invalid password".

Sincerely,
Annika
E-iceblue support team

[GerhardFinee]

Hi Annika,

sounds good, looking forward to those new features. Thank you.

KR,
Gerhard

[Annika.Zhou]

Hello Gerhard,

You're welcome.
Once the new feature achieved in the future, I will notify you in immediately.

Sincerely,
Annika
E-iceblue support team

[Annika.Zhou]

Hello,

Thanks for your patience!

Glad to inform you that we just released Spire.XLS Pack Version:12.1 which supports the IsPasswordProtected method to load the file stream。

Please download the fix version from the following links and the following code to test.

Website link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget link: https://www.nuget.org/packages/Spire.XLS/12.1.0

Code: Select all

bool havepwd = Workbook.IsPasswordProtected(File.OpenRead(inputFile));
//another way
var docBytes = File.ReadAllBytes(inputFile);
MemoryStream ms = new MemoryStream(docBytes);
bool havepwd = Workbook.IsPasswordProtected(ms);

Sincerely,
Annika
E-iceblue support team

[GerhardFinee]

Hi,

looks nice. Thank you

KR,
Gerhard

[Annika.Zhou]

Hello,

You're welcome.
If you have other questions about using Spire.XLS in the future, please feel free to contact us.

Sincerely,
Annika
E-iceblue support team