- private void button1_Click(object sender, EventArgs e)
- {
- DataTable data = new DataTable();
- data.Columns.Add("name", typeof(string));
- data.Columns.Add("amount", typeof(decimal));
- data.Columns.Add("remark", typeof(string));
- for (int i = 0; i < 100; i++)
- {
- DataRow dr = data.NewRow();
- dr["name"] = i.ToString();
- dr["amount"] = 3.14m;
- dr["remark"] = "";
- data.Rows.Add(dr);
- }
- flexgrid.DataSource = data;
- flexgrid.AllowSorting = AllowSortingEnum.None;
- flexgrid.AllowMerging = C1.Win.C1FlexGrid.AllowMergingEnum.Custom;
- C1.Win.C1FlexGrid.CellRange t1 = flexgrid.GetCellRange(6, 1, 6, 2);
- t1.StyleNew.TextAlign = C1.Win.C1FlexGrid.TextAlignEnum.CenterCenter;
- flexgrid.MergedRanges.Add(t1);
- CellRange cr = flexgrid.GetCellRange(1, 1, 14, 2);
- cr.StyleNew.Border.Color = Color.Black;
- cr.StyleNew.Border.Style = BorderStyleEnum.Double;// BorderStyleEnum.Flat;
- CellStyle cs1 = flexgrid.Styles.Add("Sumi");
- cs1.ForeColor = Color.Red;
- cs1.Font = new System.Drawing.Font("宋体", 24f);
- flexgridORg.Rows[4].Style = cs1;
- flexgridORg.Rows[4].Height = 45;
- }
- private void button2_Click(object sender, EventArgs e)
- {
- SaveFileDialog sfd = new SaveFileDialog();
- sfd.Filter = "*.xls|*.xls";
- if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
- {
- flexgrid.SaveExcel(sfd.FileName, "TEST", FileFlags.AsDisplayed | FileFlags.IncludeMergedRanges);
- MessageBox.Show("当前报表导出完成!", "操作结果", MessageBoxButtons.OK, MessageBoxIcon.Information);
- }
- }
复制代码
还是导出不了 |