Issue with using ProtectContent - Spreadsheet gear

Question

I am trying to make a selected cells of my excel to be editable and rest to be readonly.

Following is my code, I am trying to set the Locked property for the specified rows to be "False" and trying to protect the sheet

excl.WorkSheet(0).Range[0, myColumns.Count, rowCount + 2, myColumns.Count].Locked = false; // Unlock cells to not make them read-only by ProtectContents
excl.WorkSheet(0).ProtectContents = true; //Make all the locked cells read only

Say rowCount = 5, I would like to have the entire rows between 0-6 to be editable, but the rest of the fields in the workbook to be read-only.

But, the entire sheet ends up being protected rather than the cells that are locked only. Can anyone please help me fix this

Answer 1

I did this and was able to achieve what I wanted, but I am eager to know any other way to do this as well

  IRange rows = excl.WorkSheet(0).Cells[rowStart, myColumns.Count].EntireRow;
  rows.Locked = false; 
  excl.WorkSheet(0).ProtectContents = true;