Class Series

public class Series

//实例化一个 Workbook 对象
Workbook workbook = new Workbook();
//向 Excel 对象添加一个新的工作表
int sheetIndex = workbook.Worksheets.Add();
//通过传递其工作表索引获取新添加的工作表的引用
Worksheet worksheet = workbook.Worksheets[sheetIndex];
//向 "A1" 单元格添加示例值
worksheet.Cells["A1"].PutValue(50);
//向 "A2" 单元格添加示例值
worksheet.Cells["A2"].PutValue(100);
//向 "A3" 单元格添加示例值
worksheet.Cells["A3"].PutValue(150);
//向 "A4" 单元格添加示例值
worksheet.Cells["A4"].PutValue(200);
//向 "B1" 单元格添加示例值
worksheet.Cells["B1"].PutValue(60);
//向 "B2" 单元格添加示例值
worksheet.Cells["B2"].PutValue(32);
//向 "B3" 单元格添加示例值
worksheet.Cells["B3"].PutValue(50);
//向 "B4" 单元格添加示例值
worksheet.Cells["B4"].PutValue(40);
//向 "C1" 单元格添加示例值作为分类数据
worksheet.Cells["C1"].PutValue("Q1");
//向 "C2" 单元格添加示例值作为分类数据
worksheet.Cells["C2"].PutValue("Q2");
//向 "C3" 单元格添加示例值作为分类数据
worksheet.Cells["C3"].PutValue("Y1");
//向 "C4" 单元格添加示例值作为分类数据
worksheet.Cells["C4"].PutValue("Y2");
//向工作表添加图表
int chartIndex = worksheet.Charts.Add(ChartType.Column, 5, 0, 15, 5);
//访问新添加的图表的实例
Chart chart = worksheet.Charts[chartIndex];
//向图表添加 NSeries（图表数据源），范围从 "A1" 单元格到 "B4"
int seriesIndex = chart.NSeries.Add("A1:B4", true);
//为 NSeries 的分类数据设置数据源
chart.NSeries.CategoryData = "C1:C4";
Series series = chart.NSeries[seriesIndex];
//设置系列的值。
series.Values = "=B1:B4";
//更改系列的图表类型。
series.Type = ChartType.Line;
//设置标记属性。
series.Marker.MarkerStyle = ChartMarkerType.Circle;
series.Marker.ForegroundColorSetType = FormattingType.Automatic;
series.Marker.ForegroundColor = System.Drawing.Color.Black;
series.Marker.BackgroundColorSetType = FormattingType.Automatic;

//执行您的业务逻辑

//保存 Excel 文件
workbook.Save("book1.xls");

'实例化一个 Workbook 对象
Dim workbook As Workbook = New Workbook()
'向 Excel 对象添加一个新的工作表
Dim sheetIndex As Int32 = workbook.Worksheets.Add()
'通过传递其工作表索引获取新添加的工作表的引用
Dim worksheet As Worksheet = workbook.Worksheets(sheetIndex)
'向 "A1" 单元格添加示例值
worksheet.Cells("A1").PutValue(50)
'向 "A2" 单元格添加示例值
worksheet.Cells("A2").PutValue(100)
'向 "A3" 单元格添加示例值
worksheet.Cells("A3").PutValue(150)
'向 "A4" 单元格添加示例值
worksheet.Cells("A4").PutValue(200)
'向 "B1" 单元格添加示例值
worksheet.Cells("B1").PutValue(60)
'向 "B2" 单元格添加示例值
worksheet.Cells("B2").PutValue(32)
'向 "B3" 单元格添加示例值
worksheet.Cells("B3").PutValue(50)
'向 "B4" 单元格添加示例值
worksheet.Cells("B4").PutValue(40)
'向 "C1" 单元格添加示例值作为分类数据
worksheet.Cells("C1").PutValue("Q1")
'向 "C2" 单元格添加示例值作为分类数据
worksheet.Cells("C2").PutValue("Q2")
'向 "C3" 单元格添加示例值作为分类数据
worksheet.Cells("C3").PutValue("Y1")
'向 "C4" 单元格添加示例值作为分类数据
worksheet.Cells("C4").PutValue("Y2")
'向工作表添加图表
Dim chartIndex As Int32 = worksheet.Charts.Add(ChartType.Column, 5, 0, 15, 5)
'访问新添加的图表的实例
Dim chart As Chart = worksheet.Charts(chartIndex)
'向图表添加 NSeries（图表数据源），范围从 "A1" 单元格到 "B4"
Dim seriesIndex As Int32 = chart.NSeries.Add("A1:B4", True)
'为 NSeries 的分类数据设置数据源
chart.NSeries.CategoryData = "C1:C4"
Dim series As Series = chart.NSeries(seriesIndex)
'设置系列的值。
series.Values = "=B1:B4"
'更改系列的图表类型。
series.Type = ChartType.Line
'设置标记属性。
series.Marker.MarkerStyle = ChartMarkerType.Circle
series.Marker.ForegroundColorSetType = FormattingType.Automatic
series.Marker.ForegroundColor = System.Drawing.Color.Black
series.Marker.BackgroundColorSetType = FormattingType.Automatic
'保存 Excel 文件
workbook.Save("book1.xls")

public Area Area { get; }

public Bar3DShapeType Bar3DShapeType { get; set; }

public Line Border { get; }

public int BubbleScale { get; set; }

public string BubbleSizes { get; set; }

public int CountOfDataValues { get; }

public DataLabels DataLabels { get; }

public string DisplayName { get; }

public int DoughnutHoleSize { get; set; }

public DropBars DownBars { get; }

public Line DropLines { get; }

public int Explosion { get; set; }

public short FirstSliceAngle { get; set; }

public short GapWidth { get; set; }

public bool Has3DEffect { get; set; }

public bool HasDropLines { get; set; }

public bool HasHiLoLines { get; set; }

public bool HasLeaderLines { get; set; }

public bool HasRadarAxisLabels { get; set; }

public bool HasSeriesLines { get; set; }

public bool HasUpDownBars { get; set; }

public Line HiLoLines { get; }

public bool IsAutoSplit { get; }

public bool IsColorVaried { get; set; }

public bool IsFiltered { get; set; }

public bool IsVerticalValues { get; }

public SeriesLayoutProperties LayoutProperties { get; }

public Line LeaderLines { get; }

public LegendEntry LegendEntry { get; }

public Marker Marker { get; }

public string Name { get; set; }

//引用单元格的名称
chart.NSeries[0].Name = "=A1";

//设置字符串作为名称
chart.NSeries[0].Name = "第一系列";

'引用单元格的名称
chart.NSeries[0].Name = "=A1"

'设置字符串作为名称
chart.NSeries[0].Name = "第一系列"

public short Overlap { get; set; }

public bool PlotOnSecondAxis { get; set; }

public ChartPointCollection Points { get; }

public short SecondPlotSize { get; set; }

public Line SeriesLines { get; }

public bool Shadow { get; set; }

public ShapePropertyCollection ShapeProperties { get; }

public bool ShowNegativeBubbles { get; set; }

public BubbleSizeRepresents SizeRepresents { get; set; }

public bool Smooth { get; set; }

public ChartSplitType SplitType { get; set; }

public double SplitValue { get; set; }

public TrendlineCollection TrendLines { get; }

public ChartType Type { get; set; }

public DropBars UpBars { get; }

public string Values { get; set; }

public string ValuesFormatCode { get; set; }

public ErrorBar XErrorBar { get; }

public string XValues { get; set; }

public string XValuesFormatCode { get; set; }

public ErrorBar YErrorBar { get; }

public void Move(int count)