NPOI 在新版本中增加了对图表的有限支持(仅 xlsx 文件)
项目地址: https://github.com/tonyqus/npoi
支持折线图和散点图
来看 demo :
const int NUM_OF_ROWS = 3;
const int NUM_OF_COLUMNS = 10;
static void CreateChart(IDrawing drawing, ISheet sheet, IClientAnchor anchor, string serie1, string serie2)
{
var chart = drawing.CreateChart(anchor) as XSSFChart;
//生成图例
var legend = chart.GetOrCreateLegend();
//图例位置
legend.Position = LegendPosition.TopRight;
//图表
var data = chart.ChartDataFactory.CreateLineChartData<double, double>(); //折线图
//var data = chart.ChartDataFactory.CreateScatterChartData<double, double>(); //散点图
// X轴.
var bottomAxis = chart.C