Password protect Excel output?

Lee_B

Summary

Can you password protect excel outputs from BI Publisher

Content

Hi,

Not sure that this is the right place for this post, sorry if not.

I've been looking to try and password protect excel outputs from a BI Publisher report so this can be sent directly to a customer rather than having to manually do this each time they require an updated report.

I've seen that you can do this for PDF outputs and that excel was not currently available but these were older posts and wondered igf this had been rolled out to excel formats as I couldn't find any update.

Thanks

Version

11.1.1.9.0

Sricharan Monigari

Hi Lee,

Password protected excel is still not possible in the latest release.. Not sure if it is being worked upon by the development team.

Thanks,

Sricharan

Julian Challenger-Oracle

Moved to OBIEE.  Add/search for this in the IdeaLab.

Robert Fighiroae-Oracle

Hi Lee,

You can use password protect as of Release 19C for PPTX, DOCX, XLSX, PDF (the password protection will apply to both online viewed reports and scheduled jobs):

TO APPLY PASSWORD PROTECTION

• To apply password protection at server level (i.e. for all reports that generates the output in PPTX, DOCX, XLSX, PDF)

1. Navigate to Administration page
2. Open Properties under Runtime Configuration section
3. Enter a desired password for the file formats

• To apply password protection at report level (i.e. for only specific report for PPTX, DOCX, XLSX, PDF outputs)

1. Edit a report
2. Navigate to Report Properties, Formatting tab
3. Enter a desired password for the file formats

https://www.oracle.com/webfolder/technetwork/tutorials/tutorial/cloud/r13/wn/common/releases/19C/19C-common-wn.htm#F9055

NOTE: Excel output in .XLS format generated from Excel templates do not support password protection.

Kind regards,

Robert

Sricharan Monigari

Yes. password protect Excel feature has been made available since 19C. However we can set a static password only as of now. Dynamic password isn't feasible at this point of time.

Please refer the below article for detailed steps on how to achieve it.

https://fusionhcmknowledgebase.com/2019/02/now-you-can-password-protect-excel/

Thanks,
Sricharan