This project has moved. For the latest updates, please go here.

Make Column or Cell protected.

May 24, 2012 at 9:20 AM

hi all,

is there a way i can make a particular column or a cell *protected* using epplus? i still want that user should be able to edit everything else except *protected* column or cell

i've already tested .Protection property of Worksheet object but this is protecting the whole sheet :(

 

thanks in advance

Nov 12, 2012 at 12:33 PM

Hi

I have similar problem. I want to protect worksheet without some range of cells. In EPPlus I see xml:

<sheetProtection sheet="1" objects="1" scenarios="1" />
<protectedRanges><protectedRange sqref="D3:D11" name="section1" /></protectedRanges>...

but I can't find it in epplus object. Range D3:D11 is editable and was created in Excel.

Is this functionality implemented? If Yes, where it is?

Nov 12, 2012 at 12:37 PM

hmmm

I found the answer :)

worksheets.Cells[row, col].Style.Locked = false;