Forums Ignite UI for React
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
Close
Ravikrishna Punnam
15
React Excel Library Excel Header customization
posted

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?

 
Parents
No Data
Reply
  • 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.

    3377.demo.zip

Children
No Data