Wiki Markup |
---|
{introducedin: 8.6.1} {description} {excerpt}Sets or returns whether the worksheet will allow users to insert rows when the worksheet is protected.{excerpt} {signature:C#} public boolean AllowInsertRows{ get; set; } {signature}{signature:vb.net} Public Property AllowInsertRows() As Boolean {signature} {example}{code:csharp|title=C#} ExcelApplication xla = new ExcelApplication(); Workbook wb = xla.Open(@"C:\MySpreadsheet.xlsx"); Worksheet ws = wb.Worksheets[0]; ws.SheetProtection.AllowInsertRows = true; ws.Protect("password"); {code} {code:vbnet|title=vb.net} Dim xla As New ExcelApplication() Dim wb As Workbook = xla.Open("C:\MySpreadsheet.xlsx") Dim ws As Worksheet = wb.Worksheets(0) ws.SheetProtection.AllowInsertRows = true ws.Protect("password"); {code} {example} |
Page History
Overview
Content Tools