Skip to Content
0

How to EPM password

Jan 03 at 06:22 AM

31

avatar image

sheetpwd.png

Hello Team,

Using below thread i tried to get the EPM password but it is showing blank in the result for <SheetPWD>.

https://blogs.sap.com/2016/12/01/how-to-get-epm-protection-password/comment-page-1/#comment-404571

Attached screenshot for reference.

Please do the needful.

Thanks

Prasad

sheetpwd.png (3.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Prasad Rangudu Jan 03 at 08:38 AM
0

Sorry forgot to mention error message

"Object not found"

Show 1 Share
10 |10000 characters needed characters left characters exceeded

The idea of finding workbook password is simple: it's stored in the Excel name object with the name containing

EPMWorkbookOptions

check in debug - do you have this name?

0
Vadim Kalinin Jan 03 at 07:37 AM
0

Try code to Get Workbook Protection Password!

Share
10 |10000 characters needed characters left characters exceeded
Prasad Rangudu Jan 03 at 08:28 AM
0

Hi Vadim,

Yes i tried workbook code also but it is getting into error...this particular statement it is showing error...

bytArr = objNode.nodeTypedValue

But, for other reports\templates this workbook code is working fine.

Is there anything which i need to change in the logic. For worksheet logic, i am not getting any error but when i check the result it is showing as blank.

Thanks

Prasad

Show 1 Share
10 |10000 characters needed characters left characters exceeded

"it is showing error" - error screenshot?

You can always debug the code...

What do you have in strBase64?

0