Spire.XLS 教程：保护和取消保护工作表

最新推荐文章于 2023-02-16 11:28:59 发布

cocacola456

最新推荐文章于 2023-02-16 11:28:59 发布

阅读量1.2k

点赞数 1

分类专栏：资源与学习教程文章标签： Spire.XLS Excel控件资源使用教程工作表

本文链接：https://blog.csdn.net/cocacola456/article/details/77648450

版权

VSTO

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml.Linq;
using Excel = Microsoft.Office.Interop.Excel;
using Office = Microsoft.Office.Core;
using Microsoft.Office.Tools.Excel;
using System.Reflection;
 
namespace VSTO
{
    public partial class ThisAddIn
    {
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Add a new workbook
            Excel.Workbook excelApp = this.Application.Workbooks.Add();
 
            //Protect the worksheet with password
            ((Excel.Worksheet)excelApp.ActiveSheet).Protect("Spire"); 
 
            //Unprotect the worksheet specifying its password