Check Excel vba password (Cells Java)

Aspose.Cells Product Family
, ,
1

The macro code of an Excel document can be protected by a password.
Is there a way to detect whether an Excel macro is protected by a specific password? I would like to be able to validate the vba code to be protected by a specific password.

pseudo example (Java):

vbaProject.isProtectedBy("password"); // return true and only true when both the macro code is 
protected and the protection password is 'password'.
2

@RickOo,
There is no such option available in the current library, however, we have logged a ticket in our database to investigate this requirement. We will write back here once any update is available in this regard.

This requirement is logged as:
CELLSJAVA-43375 - Check Excel VBA password

3

Thank you. Where can I keep track of this feature request? What is the link?

4

@RickOo,
This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

5

@RickOo,

Please try our latest version/fix: Aspose.Cells for Java v20.12.2 (attached)

Your issue should be fixed in it. We have added a new VbaProject.ValidatePassword() method.

Let us know your feedback.
aspose-cells-20.12.2-java.zip (7.2 MB)

6

The issues you have found earlier (filed as CELLSJAVA-43375) have been fixed in this update.