在c#中使用Microsoft.Office.Interop.Excel的折线图。 [英] Line Chart using Microsoft.Office.Interop.Excel in c#.

查看:1142
本文介绍了在c#中使用Microsoft.Office.Interop.Excel的折线图。的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

我有三列 -

1。月份

2。生产

3。返回单位

 

我想在X轴上绘制月份,在Y轴上绘制其他两个。

I want to plot Month in X Axis and other two on Y axis.

我想要生产和退货单位的折线图。

I want line chart for Production and Returned Units.

那么,告诉我如何设置系列以及x和y轴值?

So, tell me how to set series as well as x and y axis values?

 

问候,

Swapnil

推荐答案

 

这很简单......按照以下步骤操作

It simple... follow the steps below

 

1。创建图表。

Excel.ChartObjects ChartObjects =(Excel.ChartObjects)excelSheet.ChartObjects();

Excel.ChartObjects ChartObjects = (Excel.ChartObjects)excelSheet.ChartObjects();

Excel.ChartObject chartObject = ChartObjects.Add( 40,1000,700,350);

Excel.ChartObject chartObject = ChartObjects.Add(40, 1000, 700, 350);

chartObject.Chart.ChartType = Excel.XlChartType.xlLineMarkers;

             chartObject.Chart.HasTitle = true;

chartObject.Chart.ChartType = Excel.XlChartType.xlLineMarkers;
            chartObject.Chart.HasTitle = true;

2。确定x轴的范围

  Excel.Range xValRange = excelSheet.Range [" A1"," A5"]

 Excel.Range xValRange = excelSheet.Range["A1","A5"]

3 。获取seriescollection

3. Get the seriescollection

Excel.SeriesCollection oSeriesCollection =(Excel.SeriesCollection)chartObject.Chart.SeriesCollection();

Excel.SeriesCollection oSeriesCollection = (Excel.SeriesCollection)chartObject.Chart.SeriesCollection();

 

然后你可以分配你想要的系列,

then you can assign as much as series you want,

for(int i = 0; i< serieses.Count; i ++)

{

for (int i = 0; i < serieses.Count; i++)
{

Excel.Series oSeries = oSeriesCollection.NewSeries();

Excel.Series oSeries = oSeriesCollection.NewSeries();

oSeries.Values = excelSheet.Range [" B1"," ; B5"];

oSeries.Values = excelSheet.Range["B1","B5"];

}

 

希望有帮助请告诉我你的意思能够解决目的......

Hope it helps please let me know if you are able to solve the purpose...


这篇关于在c#中使用Microsoft.Office.Interop.Excel的折线图。的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆