We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy. (Last updated on: November 16, 2018).
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

Syncfusion.XlsIO.ExcelSheetProtection enum

Thread ID:





94330 May 6,2010 06:19 PM UTC May 7,2010 06:52 AM UTC ASP.NET Web Forms (Classic) 1
Tags: XlsIO
Nicholas Brassington
Asked On May 6, 2010 06:19 PM UTC


I was previously using version of the Syncfusion.XlsIO and the enum ExcelSheetProtection.Default existed. In version this constant does not exist. What can I replace this constant with in version to create a similar permission set?

Thank you.


Lokesh R [Syncfusion]
Replied On May 7, 2010 06:52 AM UTC

Hi Nick,

Thank you very much for using Syncfusion products.

As you have reported in your post. The equivalent permission set in for the ExcelSheetProtection.DefaultProtect constant available in is
ExcelSheetProtection.LockedCells | ExcelSheetProtection.UnLockedCells. Below, I have also added the code snippet for the same, could you please try the code snippet and let us know if this helps you.

[C#] Code Snippet:

ExcelEngine engine = new ExcelEngine();
IApplication app = engine.Excel;
IWorkbook workBook = app.Workbooks.Create(2);

//Equivalent permission set in for the Defaultprotect option available in
workBook.Worksheets[0].Protect("Syncfusion", ExcelSheetProtection.LockedCells | ExcelSheetProtection.UnLockedCells);


Please, let us know if you have any queries.



This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Please sign in to access our forum

This page will automatically be redirected to the sign-in page in 10 seconds.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon