Make excel columns non editable using c#

Hi, here is another solution that you can try:

// Load excel file.
var file = ExcelFile.Load("input.xlsx");
var sheet = file.Worksheets.ActiveWorksheet;
 
// Set worksheet without grid lines.
sheet.ViewOptions.ShowGridLines = false;
 
// Set worksheet with protection.
sheet.Protected = true;
 
// Itarate through the required cells, set their borders and unlock them. 
var range = sheet.Cells.GetSubrange("A1", "C" + sheet.Rows.Count);
foreach (var cell in range)
{
    cell.SetBorders(MultipleBorders.Outside, Color.Black, LineStyle.Thin);
    cell.Style.Locked = false;
}
 
// Save excel file.
file.Save("output.xlsx");

Code uses this .NET Excel dll, I find it to be a good alternative to an Excel Interop.

Thank you Sunny, will try this..

Hi sanu,

You need to Unlock the whole sheet or the part which you want the user be able to edit and Lock the cells of your purpose.
Protect the sheet when you're done and that's all it takes.

try this way:
-----------------------------------------------------------