How to EPM password

[rvvprasad]

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

[rvvprasad]

Sorry forgot to mention error message

"Object not found"

[former_member186338]

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?

[rvvprasad]

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

[former_member186338]

"it is showing error" - error screenshot?

You can always debug the code...

What do you have in strBase64?

[former_member186338]

Try code to Get Workbook Protection Password!