← 返回所有博客文章

Spread for Winforms 表格控件 提供波形图功能,用于为每一个分析数据添加波形图。波形图是轻量级微图表,它可以呈现在单元格中用于可视化的展示数据。我们可以设置波形图为:列型、线型和损益型波形图类型。然而,波形图的数据需要和波形图在同一表单内。本篇文章中我们将介绍如何使用其他表单中的数据来创建波形图。

1.继承 ExcelSparkLine 类,创建自定义波形图:

  1: class CustomExcelSparkline : ExcelSparkline
  2: {
  3:     CellRangeSegmentData innerData;
  4:     public CustomExcelSparkline(int row, int column, SheetView source)
  5:         : base(row, column, string.Empty)
  6:     {
  7:         innerData = new CellRangeSegmentData(source, 0, 0, source.RowCount, source.ColumnCount, null);
  8:     }
  9:     public override object GetSparkLineData()
 10:     {
 11:         return innerData;
 12:     }
 13: }

 

2.使用自定义类创建损益型波形图:

  1: private void Form1_Load(object sender, EventArgs e)
  2: {
  3:     fpSpread1.SuspendLayout();
  4:     List<Double> dlist = new List<double>();
  5:     dlist.Add(4.5);
  6:     dlist.Add(4.8);
  7:     dlist.Add(5.5);
  8:     dlist.Add(6.0);
  9:     dlist.Add(7.5);
 10:   
 11:     SheetView sv = new SheetView();
 12:     sv.Visible = false;
 13:     sv.SheetName = Guid.NewGuid().ToString();
 14:     sv.DataSource = dlist;
 15:     fpSpread1.Sheets.Add(sv);
 16:     fpSpread1.Sheets[0].RowCount = 10;
 17:     fpSpread1.Sheets[0].ColumnCount = 10;
 18:     for (int r = 0; r < fpSpread1.Sheets[0].RowCount; r++)
 19:     {
 20:         FarPoint.Win.Spread.SparklineType type = SparklineType.Column;
 21:         if (r % 3 == 1)
 22:             type = SparklineType.Line;
 23:         else if (r % 3 == 2)
 24:             type = SparklineType.Winloss;
 25:         FarPoint.Win.Spread.ExcelSparklineGroup esg = new FarPoint.Win.Spread.ExcelSparklineGroup(new FarPoint.Win.Spread.ExcelSparklineSetting(), type);
 26:         for (int c = 0; c < fpSpread1.Sheets[0].ColumnCount; c++)
 27:         {
 28:             CustomExcelSparkline es = new CustomExcelSparkline(r, c, sv);
 29:             esg.Add(es);
 30:         }
 31:         fpSpread1.Sheets[0].SparklineContainer.Add(esg);
 32:     }
 33:     fpSpread1.ResumeLayout();
 34: }

 

效果图:

SpreadSparkline-300x115

Demo 下载: