用Dev的ChartControl绘制圆滑曲线并插到excel中！

最新推荐文章于 2021-01-08 14:10:02 发布

IThuas

最新推荐文章于 2021-01-08 14:10:02 发布

阅读量457

点赞数

本文链接：https://blog.csdn.net/qq_29093033/article/details/89349219

版权

public static void AddChartControl(ExcelPackage package, List<HisCycleLayerUnit> cycList, string picPath)
{
ChartControl spineChart = new ChartControl();

Series series1 = new Series("充电容量", ViewType.Spline);
Series series2 = new Series("放电容量", ViewType.Spline);
series1.Points.Add(new SeriesPoint(1, 2));
series1.Points.Add(new SeriesPoint(2, 5));
series1.Points.Add(new SeriesPoint(3, 3));
series1.Points.Add(new SeriesPoint(4, 8));

series2.Points.Add(new SeriesPoint(2, 4));
series2.Points.Add(new SeriesPoint(3, 7));
series2.Points.Add(new SeriesPoint(4, 5));
series2.Points.Add(new SeriesPoint(5, 10));

SplineSeriesView view1 = new SplineSeriesView();
view1.Color = Color.Red;

SplineSeriesView view2 = new SplineSeriesView();
view2.Color = Color.Black;

series1.View = view1 ;
series2.View = view2;

// ((LineSeriesView)series1.View).LineMarkerOptions.Visible = false;
// ((LineSeriesView)series2.View).LineMarkerOptions.Visible = false;

spineChart.Series.Add(series1);
spineChart.Series.Add(series2);

series1.ArgumentScaleType = ScaleType.Numerical;
series2.ArgumentScaleType = ScaleType.Numerical;

XYDiagram diagram = (XYDiagram)spineChart.Diagram;

diagram.AxisX.GridLines.Color = Color.Red;
diagram.AxisX.Title.Visibility = DefaultBoolean.True;
diagram.AxisX.Title.Alignment = StringAlignment.Center;
diagram.AxisX.Title.Text = "时间";
diagram.AxisX.Title.EnableAntialiasing = DefaultBoolean.True;
diagram.AxisX.Title.Font = new Font("Tahoma", 12, FontStyle.Bold);

diagram.AxisY.GridLines.Color = Color.YellowGreen;
diagram.AxisY.Title.Visibility = DefaultBoolean.True;
diagram.AxisY.Title.Alignment = StringAlignment.Center;
diagram.AxisY.Title.Text = "纵XX";
diagram.AxisY.Title.EnableAntialiasing = DefaultBoolean.True;
diagram.AxisY.Title.Font = new Font("Tahoma", 12, FontStyle.Bold);

((XYDiagram)spineChart.Diagram).EnableAxisXZooming = true;
spineChart.Titles.Add(new ChartTitle());
spineChart.Titles[0].Text = "循环数据曲线";
spineChart.Titles[0].Font = new Font("Tahoma", 14, FontStyle.Bold);
spineChart.Dock = DockStyle.Fill;

// spineChart.ExportToImage();

// ExcelWorksheet worksheet = package.Workbook.Worksheets.Add("曲线图");

PrintingSystem ps = new PrintingSystem();
CompositeLink link = new CompositeLink(ps);
ps.Links.Add(link);
link.Links.Add(CreatePrintableLink(spineChart));
link.Landscape = true;
XlsxExportOptions options = new XlsxExportOptions();
link.ExportToXlsx(picPath, options);

}