I am binding data to spreadsheet.Can I make spreadsheet non editable?
I want something like as below
this.spreadsheet.workbook.worksheets(0).Editable=False:
User should not able to edit excel sheet.User can only see excel in read mode.
Can you please help me
Hello,
I have been looking into your question and an approach I could suggest is to mark the worksheet as protected. This could be done via the protect method. More about configuring protection as well as a small demo that you might consider useful could be found in this topic in our documentation.
Let me know if I may be of any further assistance.Sincerely,Teodosia HristodorovaSoftware Developer
Thanks for the quick response.
I have one more question. Can I delete particular rows from spreadsheet as below
this.spreadsheet.workbook.worksheets(0).DeleteRow(0,2);