The use of shared Excel files refers to collaborating on and editing Microsoft Excel spreadsheets simultaneously with multiple users. Sharing Excel files can be valuable in various scenarios where collaboration and real-time updates are essential. This article demonstrates how to create shared Excel files in C#. Also, it shows how to apply protection to shared Excel files.
Create and Protect a Shared Excel Workbook in C#
Microsoft Excel allows you to create a shared Excel workbook. When you share a workbook, more than one user can edit it. Aspose.Cells for .NET enables you to create a shared workbook with Workbook.Settings.Shared property. Also, you can protect or unprotect a shared workbook.
To read a complete article on how to create Excel files from scratch, visit this article.
The following section provides you with the steps and code sample on how to create a shared Excel file.
Create a Shared Excel Workbook in C#
- Create an Excel file (or load existing one) using Workbook class.
- Set Workbook.Settings.Shared property to true.
- Save the updated Excel file using Workbook.Save() method.
The following is the code sample to create a shared Excel file in C#.
Protect a Shared Excel Workbook
You can also protect a shared Excel file with ease. Simply call ProtectSharedWorkbook method after creating or loading the Excel file. The following code sample shows how to protect a shared Excel file.
Get a Free License for C# Excel API
You can get a free license to create shared Excel files without any evaluation limitations.
Aspose.Cells for .NET Resources
The resources, you may need to accomplish your tasks: