Protect spread sheet with password and export to excel

Posted by: rbspreaduser on 8 September 2017, 3:23 pm EST

  • Posted 8 September 2017, 3:23 pm EST

    Hi.. I am using Spread 6 (WinForm).

    I use below code to protect sheet and export to excel :

                
    FpSpread FpSpread1 = new FpSpread();
    FpSpread1.Sheets[0].Protect = true;
    FpSpread1.SaveExcel("filePath");


    Problem : When I open this excel file, I found that sheet is protected without a password.

    Requirement : I know we can export excel workbook with a password using SaveExcel method.
    But I need a method to export sheet with a password in excel workbook. i.e, when I try to unprotect sheet in excel application, I should be asked to input same password.


    Many thanks in advance.
    Best Regards,
    Rajesh
  • Marked as Answer

    Replied 8 September 2017, 3:23 pm EST

    Hello,

    There is no way to password protect a single sheet, hence we are escalating the same to the concerned team as an enhancement.

    Tracking id for your issue is #152917

    We will update you once we hear anything from them.

    Thanks,
    Reeva
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels