Protect spread sheet with password and export to excel

Posted by: rbspreaduser on 8 September 2017, 6:23 am EST

  • Posted 8 September 2017, 6:23 am 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;

    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,
  • Marked as Answer

    Replied 8 September 2017, 6:23 am EST


    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.

  • Replied 4 February 2020, 4:31 am EST

    Is this feature available in SpreadJS Version 11 ?

Need extra support?

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

Learn More

Forum Channels