- NPOI
- Spire.XLS
- Download Sample Code
using NPOI.SS.UserModel;
using NPOI.XSSF.UserModel;
using System;
using System.Collections.Generic;
using System.IO;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
namespace NPOI
{
class Program
{
static void Main(string[] args)
{
//Create workbook
IWorkbook workbook = new XSSFWorkbook();
//Create a new sheet
ISheet sheet = workbook.CreateSheet("newSheet");
//Protect the sheet
sheet.ProtectSheet("test");
//Save the file
FileStream file = File.Create("Protected.xlsx");
workbook.Write(file);
file.Close();
//Launch
System.Diagnostics.Process.Start("Protected.xlsx");
}
}
}
using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Xls;
namespace Spire.XLS
{
class Program
{
static void Main(string[] args)
{
//Create workbook
Workbook workbook = new Workbook();
//Create an empty worksheet
Worksheet sheet = workbook.CreateEmptySheet("newSheet");
//Protect the sheet
sheet.Protect("test");
//Save and Launch
workbook.SaveToFile("Protected.xlsx", ExcelVersion.Version2013);
System.Diagnostics.Process.Start("Protected.xlsx");
}
}
}
