We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Locking cells in a worksheet of excel

Hi,

I have a task where i have to create cells in a worksheet,so that only selected cells should be editable or writable and other cells should be read only. Should i protect the whole worksheet or how can i lock certain cells in a worksheet. Please help with some code.

Thanx in advance.

Hi,

Kindly check the following documentation topics for your need:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/protecting-worksheets.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/advanced-protection-settings-since-excel-xp.html

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/unprotect-a-worksheet.html

Thank you.