如何在C#中在EXCEL中添加图表？

Question

如题。

Answer 1

最好用vb.net
        Dim chart As Excel.Chart
        chart = SheetActive.ChartObjects.Add(LeftPos, TopPos, Width, Height).Chart
        With chart
            .HasLegend = False
            .ChartType = Excel.XlChartType.xlColumnClustered
            .SeriesCollection.NewSeries()
            .SeriesCollection(1).XValues = AxisRa.Value
            .SeriesCollection(1).Values = ValRa.Value
            .PlotArea.Border.LineStyle = Excel.XlLineStyle.xlLineStyleNone
            .PlotArea.Interior.ColorIndex = Excel.XlColorIndex.xlColorIndexNone
       End With