How to protect excel sheet in d365fo

(0) Share

Report

Posted on by js lee

Hello.

I asked 2 questions, but I didn't get the answer I wanted, so I'm writing.

I want to do 'excel sheet protection' when I make excel file in d365fo, but I only got indirect answers.

I want a direct code that does excel sheet protection.

Thank you for reading the question

All responses (2)

Answers (0)

Martin Dráb 229,857 Most Valuable Professional on at

Like (1)

Report
How to protect excel sheet in d365fo

Good! I'm glad you found in the end that the approach I suggested indeed solves the problem.

For reference, the discussion is split to three threads with the same name. If anyone is interested in details, please refer to them.

https://community.dynamics.com/forums/thread/details/?threadid=f5caef5f-ec3f-ee11-bdf3-000d3a55bcf1

https://community.dynamics.com/forums/thread/details/?threadid=bab21374-2843-ee11-bdf4-00224827e5da

js lee, please use replies next times, instead of creating several new threads on the same topic.
js lee 25 on at

Like (0)

Report

How to protect excel sheet in d365fo

After many attempts, we succeeded as follows

ExcelSheetProtection _Protection = worksheet.protection;

_Protection.isProtected = true;
_Protection.SetPassword("123");
package.Save();