DataExcel 设置表格编辑控件 CellGridView

来源：互联网发布：金十数据是真的吗编辑：程序博客网时间：2024/06/16 06:59

解决的问题：

DataExcel内嵌入表格解决数据查询。大量数据显示的问题

配套有表格事件,Action,函数后续更新相关内容

            ///清除所有行，列，合并单元格，扩展单元格，等            dataexcel1.Clear();            ///初始化默认行，列            dataexcel1.Init();            dataexcel1.MergeCell("B2", "H2");            dataexcel1["B2"].Value = "表格示例";            ICell cell = dataexcel1.MergeCell("B3", "H13");            //创建单元格编辑控件 传入单元格            Feng.Excel.Edits.CellGridView gridview = new Feng.Excel.Edits.CellGridView(cell);            GridViewColumn column = gridview.Columns.Add("单号");            column.Width = 100;            gridview.Columns.Add(column);            column = gridview.Columns.Add("名称");            column.Width = 120;            gridview.Columns.Add(column);            column = gridview.Columns.Add("日期");            column.Width = 80;            gridview.Columns.Add(column);            column.OwnEditControl = new Feng.Forms.Controls.GridControl.Edits.CellDateTime();            column = gridview.Columns.Add("地址");            column.Width = 180;            gridview.Columns.Add(column);            cell.OwnEditControl = gridview;            DataTable table = new DataTable();            table.Columns.Add("单号");            table.Columns.Add("名称");            table.Columns.Add("地址");            table.Columns.Add("日期");            for (int i = 0; i < 1000; i++)            {                DataRow row = table.NewRow();                row["单号"] = (i + 100000).ToString();                row["名称"] = (i + 100000).ToString();                row["地址"] = (i + 100000).ToString();                row["日期"] = DateTime.Now.AddDays(i % 100);                table.Rows.Add(row);            }            cell.Value = table;

阅读全文

0 0