DataExcel控件的单元格选与合并单元格

来源：互联网发布：cctv10讲述淘宝苹果编辑：程序博客网时间：2024/04/24 12:51

        DataExcel dataexcel1 = new DataExcel();        /// <summary>        /// 选中单元格        /// </summary>        public void Select()        {            //能过字符串合并            ISelectCellCollection SelectCell = dataexcel1.SelectCell("A1:F1");            SelectCell.BackColor = Color.Red;            //能过单元格合并            ICell cellA2 = dataexcel1["A2"];            ICell cellF2 = dataexcel1["F2"];            SelectCell = dataexcel1.SelectCell(cellA2, cellF2);            SelectCell.BackColor = Color.Gray;            //能过字符串合并            SelectCell = dataexcel1.SelectCell("A3", "F3");            SelectCell.BackColor = Color.Blue;            dataexcel1.Save(dataexcel1.Version + "_" + DateTime.Now.ToString("yyMMddHHmmss") + ".dat");        }        /// <summary>        /// 合并单元格        /// </summary>        public void Merge()        {            //能过字符串合并            IMergeCell MergeCell = dataexcel1.MergeCell("A1:F1");            MergeCell.BackColor = Color.AliceBlue;            MergeCell.Text = "A1:F1";            //能过单元格合并            ICell cellA2 = dataexcel1["A2"];            ICell cellF2 = dataexcel1["F2"];            MergeCell = dataexcel1.MergeCell(cellA2, cellF2);            MergeCell.BackColor = Color.AntiqueWhite;            MergeCell.Text = "A2:F2";            //能过字符串合并            MergeCell = dataexcel1.MergeCell("A3", "F3");            //合并当前选择的单元格            dataexcel1.SelectCell("A4", "F4");//选择单元格            MergeCell = dataexcel1.MergeCell();            MergeCell.BackColor = Color.Aqua;            MergeCell.Text = "A4:F4";            dataexcel1.Save(dataexcel1.Version + "_" + DateTime.Now.ToString("yyMMddHHmmss") + ".dat");        }

效果:

阅读全文

0 0

DataExcel控件的单元格选 与合并单元格

DataExcel控件的单元格选与合并单元格