Set readonly column in closedxml column

Question

I got stuck for setting "ReadOnly" column using "ClosedXML" utility for export to Excel. I am able to export records into Excel, however the first "ID" column I need to keep it read only, user should not type anything. If he want to add new row in the exported excel he can, except "ID" column. Please help me to solve this functionality (ws is my worksheet).

ws.Column("ID").Style.Protection.SetLocked(true);

Even I am setting "SetLocked" it is editable and I need non-editable field.

Possible duplicate of [Set lock true for group of cells](http://stackoverflow.com/questions/20286191/set-lock-true-for-group-of-cells) — Raidri, Sep 21 '16 at 08:46

score 3 · Answer 1 · answered Jul 13 '20 at 07:38

3

at first you need to protect the whole sheet then unlock only the cells you want to be editable as following

ws.Protect("yourPassword"); //hint: password parameter is optional
ws.Column("ID").Style.Protection.SetLocked(false); //set to false

answered Jul 13 '20 at 07:38

khaled saleh

470
7
18

Raidri · Answer 2 · 2018-10-26T23:34:47.633

2

You need to also switch protection on for the worksheet with

ws.Protect()

See the documentation and this question for more details.

edited Oct 26 '18 at 23:34

answered Sep 20 '16 at 14:16

Raidri

17,258
9
62
65

Set readonly column in closedxml column

2 Answers2