How to protect particular row with respect to particular column(say column N) based on the value present in the column(say Column J which has value of 20000)?

  1. Excel gets generated from data table. The excel file has A to N
    Column. The column A to K should be protected. Column L to N should not
    be protected. This is done by using aspose.cells.

    2. J column
    has some values. If the value in J is 20000 then that row should be
    protected till the column L. Through aspose.cells how to do this in
    addition to the point 1.

    I tried but could not protect that.

Hi Harish,


Please review our response on your other thread with details on how you can search a particular value and lock the corresponding row.