c#/vb.net excel 表格中锁定指定单元格-k8凯发天生赢家

pm> install-package spire.xls

using spire.xls;
namespace lockcells
{
    class program
    {
        static void main(string[] args)
        {
            //创建 workbook 类的对象
            workbook workbook = new workbook();
            //载入 excel 表格
            workbook.loadfromfile(@"c:\示例.xlsx");
            //获取第一个工作表
            worksheet sheet = workbook.worksheets[0];
            //解锁该工作表中所有已使用的单元格
            cellrange usedrange = sheet.range;
            usedrange.style.locked = false;
            //锁定指定单元格
            cellrange cells = sheet.range["a1:f2"];
            cells.style.locked = true;
            //用密码保护该工作表
            sheet.protect("123456", sheetprotectiontype.all);
            //保存 excel 表格
            workbook.savetofile("锁定单元格.xlsx", excelversion.version2016);
        }
    }
}

imports spire.xls
namespace lockcells
    class program
        shared sub main(byval args() as string)
            '创建 workbook 类的对象
            dim workbook as workbook = new workbook()
            '载入 excel 表格
            workbook.loadfromfile("c:\示例.xlsx")
            '获取第一个工作表
            dim sheet as worksheet = workbook.worksheets(0)
            '解锁该工作表中所有已使用的单元格
            dim usedrange as cellrange = sheet.range
            usedrange.style.locked = false
            '锁定指定单元格
            dim cells as cellrange = sheet.range("a1:f2")
            cells.style.locked = true
            '用密码保护该工作表
            sheet.protect("123456", sheetprotectiontype.all)
            '保存 excel 表格
            workbook.savetofile("锁定单元格.xlsx", excelversion.version2016)
        end sub
    end class
end namespace