//create a new workbook var workbook = new GrapeCity.Documents.Excel.Workbook(); IWorksheet worksheet = workbook.Worksheets[0]; //config range B1's Locked property. worksheet.Range["B1"].Locked = false; //protect worksheet, range B1 can be modified in exported xlsx file. worksheet.Protection = true; // Save to an excel file workbook.Save("SetRangeLocked.xlsx");
' Create a new Workbook Dim workbook As New Workbook Dim worksheet As IWorksheet = workbook.Worksheets(0) 'config range B1's Locked property. worksheet.Range!B1.Locked = False 'protect worksheet, range B1 can be modified in exported xlsx file. worksheet.Protection = True ' save to an excel file workbook.Save("SetRangeLocked.xlsx")