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. Image for the cookie policy date
Syncfusion Feedback

Trusted by the world’s leading companies

Syncfusion Trusted Companies

Overview

The Syncfusion® .NET Excel Library (XlsIO) allows users to protect and unprotect Excel files in C# and VB.NET with various customization options. This prevents unnecessary data loss or modifications to Excel worksheets while making them available to others with limited access.

Encryption Code Example

This example code shows how to encrypt an Excel workbook with a password using the Syncfusion® .NET Excel Library with just a few lines of C# code.

// Initialize Excel engine and application
using ExcelEngine excelEngine = new ExcelEngine();
IApplication application = excelEngine.Excel;
application.DefaultVersion = ExcelVersion.Xlsx;
// Create a workbook and worksheet
IWorkbook workbook = application.Workbooks.Create(1);
// Encrypt the workbook with a password
workbook.PasswordToOpen = "syncfusion";
// Save the Excel document
using FileStream stream = new FileStream("EncryptedWorkbook.xlsx", FileMode.Create, FileAccess.ReadWrite);
workbook.SaveAs(stream);

Key Functions of Security

Discover how the Security features in the Syncfusion® Excel Library enhance data protection by providing robust mechanisms to safeguard Excel files from unauthorized access.

Encrypt Workbook

Add password protection to an Excel workbook to restrict access, ensuring that only authorized users can open and modify its contents.

Decrypt Workbook

Remove password protection from an Excel workbook, allowing access to its contents for editing and viewing without restrictions.

Protect Workbook

Secure the workbook with a password, preventing unauthorized changes to its structure.

Protect Worksheet

Lock a worksheet with a password, preventing unauthorized edits to its content while allowing specific actions based on permissions.

Unprotect Worksheet

Remove protection from a worksheet, granting full access to all content for editing or formatting purposes.

Protect cell

Lock specific cells within a worksheet, restricting edits to ensure data integrity while allowing modifications to other cells.

Explore Security references

Discover valuable resources from our knowledge base articles to enhance your efficiency in using security.

Easy Ways to Protect Excel Data in C#

Blog

5 Easy Ways to Protect Excel Data in C#

Protect certain cells in C#, VB.NET and WinForms Excel

Knowledge base

How to protect certain cells in C#, VB.NET and WinForms Excel

Unlock cells and protect the worksheet for formatting columns in C#, VB.NET

Knowledge base

Unlock cells and protect the worksheet for formatting columns in C#, VB.NET

Syncfusion .NET Excel Library Resources

Explore these resources for comprehensive guides, knowledge base articles, insightful blogs, and ebooks.

Frequently Asked Questions

Yes. You can remove a password from an Excel document by changing the password value to empty using the Syncfusion® .NET Excel library.

You can use Workbook protection, which uses the Syncfusion® Excel library to prevent adding or removing worksheets in the Excel document.

You can use the encryption feature from the Syncfusion® Excel library to set a password for the Excel document. This will ensure that only specific users with passwords can read the content.

You can open an Excel document in read-only mode by setting the ReadOnlyRecommended value to true using the Syncfusion® Excel library.

No. You can provide any combination of passwords for Excel documents.

No. It is not possible to open encrypted Excel documents without a password.

Our Customers Love Us

Having an excellent set of tools and a great support team, Syncfusion® reduces customers’ development time.
Here are some of their experiences.

Rated by users across the globe

Want to create, View, and edit Excel files in C# or VB.NET?

Start a free 30-day evaluation today!
DOWNLOAD FREE TRIAL

No credit card required.

Mobile Free Evaluation Section

Awards

Greatness—it’s one thing to say you have it, but it means more when others recognize it. Syncfusion® is proud to hold the following industry awards.

Scroll up icon