DataExcel 设置单元格，列，行只读 ReadOnly属性

最新推荐文章于 2023-07-18 09:30:00 发布

足球中国

最新推荐文章于 2023-07-18 09:30:00 发布

阅读量2.6k

点赞数

分类专栏：文件服务器&&.net excel控件&&jsexcel控件 .net

本文链接：https://blog.csdn.net/zanfeng/article/details/76189428

版权

.net 同时被 2 个专栏收录

81 篇文章 0 订阅

订阅专栏

文件服务器&&.net excel控件&&jsexcel控件

36 篇文章 1 订阅

订阅专栏

  ///清除所有行，列，合并单元格，扩展单元格，等
            dataexcel1.Clear();
            ///初始化默认行，列
            dataexcel1.Init();
             
            //获取行 通过GetRow函数获取行会自动创建行 
            IRow row = dataexcel1.GetRow(1);
            row.Height = 30; 
            row = dataexcel1.GetRow(2);
            //设置行只读
            row.InhertReadOnly = false;
            row.ReadOnly = true;
            row.BackColor = Color.AliceBlue;
            row.Height = 30;
            row = dataexcel1.GetRow(3);
            row.Height = 30;

            IColumn column = dataexcel1.GetColumn(1);
            column.Width = 120; 
            column = dataexcel1.GetColumn(2);
            //设置列只读
            column.InhertReadOnly = false;
            column.ReadOnly = true;
            column.Width = 120;
            column.BackColor = Color.AntiqueWhite;
            column = dataexcel1.GetColumn(3);
            column.Width = 120;
            column = dataexcel1.GetColumn(4);
            column.Width = 120;

            ICell cell = dataexcel1[1, 1];
            cell.Name = "name1";
            cell.Value = "只读单元格";
            //设置单元格只读
            cell.ReadOnly = true;
            cell.InhertReadOnly = false;

            cell = dataexcel1[2, 1];
            cell.Name = "name2";
            cell.Value = "只读单元格";
            //设置单元格只读
            cell.ReadOnly = true;
            cell.InhertReadOnly = false;


            cell = dataexcel1[3, 2];
            cell.Value = "只读列";


            cell = dataexcel1[2, 4];
            cell.Value = "只读行";

效果如图: