Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
React Excel Library Excel Header customization

Hello, I am trying to use React Excel Library, and downloaded the code , so when the excel sheet is downloading , can we make only the header file a readonly (Non editable)? Name,Age,company ,Title,country Fields, can we make it as readonly text?

No Data
  • 34310
    Offline posted

    Hello Ravikrishna,

    I have been investigating into your requirement to make certain cells read-only using the Infragistics Excel Library in Ignite UI for React, and in order to do this, you will need to set the locked property of the corresponding cell’s CellFormat property to true and mark the Worksheet protected by calling the protect() method.

    The WorksheetCell.cellFormat.locked property is a nullable boolean, and so if you want the other cells to be editable after calling the protect() method, you will need to set their properties to false, otherwise they will also be considered protected.

    I am attaching a sample project to demonstrate the above. I hope this helps you.

    Please let me know if you have any other questions or concerns on this matter.

No Data