怎样用c＃操作excel里的chart对象

最新推荐文章于 2020-11-10 15:24:42 发布

一直活在明天

最新推荐文章于 2020-11-10 15:24:42 发布

阅读量2.3k

点赞数

分类专栏： .net 文章标签： excel c charts

.net 专栏收录该内容

30 篇文章

订阅专栏

public void CreateChart()
{
    Excel.Worksheet thisWorksheet;
    thisWorksheet = thisWorkbook.ActiveSheet as Excel.Worksheet;
    Excel.ChartObjects charts =
        (Excel.ChartObjects)thisWorksheet.ChartObjects(Type.Missing);

    // Adds a chart at x = 100, y = 300, 500 points wide and 300 tall.
    Excel.ChartObject chartObj = charts.Add(100, 300, 500, 300);
    Excel.Chart chart = chartObj.Chart;

    // Gets the cells that define the bounds of the data to be charted.
    Excel.Range chartRange = thisWorksheet.get_Range("A5","D8");
    chart.SetSourceData(chartRange,Type.Missing);

    chart.ChartType = Excel.XlChartType.xlXYScatter;
    Excel.SeriesCollection seriesCollection=
        (Excel.SeriesCollection)chart.SeriesCollection(Type.Missing);
    Excel.Series series = seriesCollection.Item(seriesCollection.Count);
}
Find something in google.

Excel excel = new Excel();
            Worksheet sheet = excel.Worksheets[0];

            Cells cells = sheet.Cells;
            cells[0,1].PutValue("Income");
            cells[1,0].PutValue("Company A");
            cells[2,0].PutValue("Company B");
            cells[3,0].PutValue("Company C");
            cells[1,1].PutValue(10000);
            cells[2,1].PutValue(20000);
            cells[3,1].PutValue(30000);

            int chartIndex = sheet.Charts.Add(ChartType.Column, 9, 9, 21, 15);

            Chart chart = sheet.Charts[chartIndex];
            chart.NSeries.Add("B2:B4", true);
            chart.NSeries.CategoryData = "A2:A4";

            ASeries aSeries = chart.NSeries[0];
            aSeries.Name = "=B1";
            chart.IsLegendShown = true;
            chart.Title.Text = "Income Analysis";