C#向EXCEL中插入图表对象，并设置标题

最新推荐文章于 2020-12-23 21:27:14 发布

lemonxuwei

最新推荐文章于 2020-12-23 21:27:14 发布

阅读量4.5k

点赞数

分类专栏： C# 文章标签： excel c# charts string

本文链接：https://blog.csdn.net/lemonxuwei/article/details/7312354

版权

C# 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

        /// <summary>
        /// 在当前sheet中插入图表
        /// </summary>
        /// <param name="range">数据源</param>
        /// <param name="xlChartType">图类型</param>
        /// <param name="chartTitle">标题</param>
        /// <param name="chartLeft">左</param>
        /// <param name="chartTop">上</param>
        /// <param name="chartWidth">宽</param>
        /// <param name="chartHeight">高</param>

        public void InsertChart(string range, XlChartType xlChartType, string chartTitle, double chartLeft, double chartTop, double chartWidth, double chartHeight)
        {
            Microsoft.Office.Interop.Excel.Worksheet worksheet = (Microsoft.Office.Interop.Excel.Worksheet)myExcel.ActiveSheet;
            ChartObjects charts = (ChartObjects)worksheet.ChartObjects(Type.Missing);
            ChartObject chartObj = charts.Add(chartLeft, chartTop, chartWidth, chartHeight);
            Chart chart = chartObj.Chart;
            chart.Legend.Clear();
            chart.ChartType = xlChartType;
            Range rg = worksheet.get_Range(range, Type.Missing);
            chart.SetSourceData(rg, Type.Missing);
            if (chart.HasTitle)
            {
                chart.ChartTitle.Text = chartTitle;
            }
            else
            {
                chart.HasTitle = true;
                chart.ChartTitle.Text = chartTitle;
            }

        }