Hi Divya,

Yes please do update me once you get any update from the development team.

Hi Divya,

You have again suggested me an answer for ASP.Net MVC. I have already shared the context, I need answer for Jquery Library.

Now my only query is, How can we make the excel sheet password protected using ignite ?UI jquery library?

I achieved this with the following code/steps:

1. By first making the entire excel sheet protected by using the code:

    sheet.protect();                   {sheet is my worksheet name}

2. Then by unlocking certain cells of excel sheet using the code:

    sheet.getCell('H'+j).cellFormat().locked(false);          {where H is the column name and j is a row number, an integer value}

Hope that helps someone else.

I am using Ignite UI's Jquery excel Library.

Hi Divya,

The post you have shared is about locking cells in C#. I want to lock/unlock certain cells using the JavaScript Library. The language has to be JS. Please reply ASAP.