Advanced Protection



I need to be able to protect a worksheet but also allow row insertions. If I go through Excel, the protection dialog gives me a list of allowable user actions that I can check, including “Insert rows”. Is there a way to enable the same protection through Aspose?



Hi Mark,

Do you use ExcelXP or Excel2003? Please use Worksheet.Protection property for this purpose.

Excel excel = new Excel();
excel.Worksheets[0].Protection.IsInsertingRowsAllowed = true;