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;
    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, 6:23 am 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
  • Replied 4 February 2020, 4:31 am EST

    Hello,
    Is this feature available in SpreadJS Version 11 ?

    Thanks,
Need extra support?

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

Learn More

Forum Channels