Excel API Library for .NET - Sample Browser | Document Solutions | Lock range

[フレーム]

IRange.Locked determines whether the cell can be modified in exported Excel when the sheet is protected.


 
 //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")