Posted 8 September 2017, 6:23 am ESTHi.. I am using Spread 6 (WinForm).
I use below code to protect sheet and export to excel :
FpSpread FpSpread1 = new FpSpread();
FpSpread1.Sheets.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.