Set lock true for group of cells

c#, closedxml, export-to-excel

Solution

You can use `Range` like so

workSheet.Range(startRow, startColumn, endRow, endColumn).Style.Protection.SetLocked(true);

Problem

I'm using closedxml to export excel.. Now i can protect (Lock cell) cell using the following function, ``` workSheet.Cell(rowIndex,column).Style.Protection.SetLocked(true); ``` I want to set group of cells.. Is that Possible in closedxml ?

Original source