本文整理汇总了C#中Workbook.Protect方法的典型用法代码示例。如果您正苦于以下问题:C# Workbook.Protect方法的具体用法?C# Workbook.Protect怎么用?C# Workbook.Protect使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Workbook
的用法示例。
在下文中一共展示了Workbook.Protect方法的2个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: Main
static void Main(string[] args)
{
//Specify the template excel file path.
string myPath = "Book1.xls";
//Instantiate a new Workbook.
//Open the excel file.
Workbook workbook = new Workbook(myPath);
//Protect the workbook specifying a password with Structure and Windows attributes.
workbook.Protect(ProtectionType.All, "007");
//Unprotect the workbook specifying its password.
workbook.Unprotect("007");
//Save As the excel file.
workbook.Save("MyBook.xls");
}
示例2: btnRun_Click
private void btnRun_Click(object sender, System.EventArgs e)
{
Workbook workbook = new Workbook();
//Initailize worksheet
workbook.CreateEmptySheets(1);
Worksheet sheet = workbook.Worksheets[0];
//Protect workshet
sheet.Protect( this.textBox1.Text );
//Protect cells
sheet.Range["A1"].Text = "Locked";
sheet.Range["B1"].Text = "Unlocked";
sheet.Range["A1"].Style.Locked = true;
sheet.Range["B1"].Style.Locked = false;
//Protect workbook
workbook.Protect(this.textBox1.Text);
workbook.SaveToFile("Sample.xls");
ExcelDocViewer(workbook.FileName);
}