Protect spread sheet with password and export to excel

Protect spread sheet with password and export to excel

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

• 

  rbspreaduser

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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 :

  [csharp]
  
  FpSpread FpSpread1 = new FpSpread();
  
  FpSpread1.Sheets[0].Protect = true;
  
  FpSpread1.SaveExcel(“filePath”);
  
  [/csharp]

  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

• 

  reeva

  • Post Options:
  • Link
    Copy

  Posted 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

• 

  Hasitha.Gunasinghe

  • Post Options:
  • Link
    Copy

  Posted 4 February 2020, 4:31 am EST

  Hello,
  
  Is this feature available in SpreadJS Version 11 ?

  Thanks,