本文整理汇总了C#中Microsoft.Office.Interop.PowerPoint.SeriesCollection方法的典型用法代码示例。如果您正苦于以下问题：C# Microsoft.Office.Interop.PowerPoint.SeriesCollection方法的具体用法？C# Microsoft.Office.Interop.PowerPoint.SeriesCollection怎么用？C# Microsoft.Office.Interop.PowerPoint.SeriesCollection使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类Microsoft.Office.Interop.PowerPoint的用法示例。
在下文中一共展示了Microsoft.Office.Interop.PowerPoint.SeriesCollection方法的3个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: GetChartSeriesByName
public PPT.Series GetChartSeriesByName(PPT.Chart chart, string seriesName)
{
var sc = (PPT.SeriesCollection)chart.SeriesCollection();
PPT.Series seriesToReturn = null;
int counter = 1;
int total = sc.Count + 1;
do
{
var series = sc.Item((counter));
if (series.Name == seriesName)
{
seriesToReturn = series;
}
counter++;
}
while (counter != total);
return seriesToReturn;
}示例2: GetAllChartSeries
public PPT.SeriesCollection GetAllChartSeries(PPT.Chart chart)
{
return (PPT.SeriesCollection)chart.SeriesCollection();
}示例3: AddSeriesToExistingChart
public void AddSeriesToExistingChart(PPT.Chart chart, ChartSeries series)
{
var workbook = (EXCEL.Workbook)chart.ChartData.Workbook;
workbook.Windows.Application.Visible = false;
var cellNumber = 1;
var dataSheet = (EXCEL.Worksheet)workbook.Worksheets[1];
var sc = (PPT.SeriesCollection)chart.SeriesCollection();
var seriesCount = sc.Count;
var letter = IntToLetters((seriesCount + 2));
foreach (var value in series.seriesData)
{
var cellPosition = letter + cellNumber.ToString();
dataSheet.Cells.Range[cellPosition].Value2 = value;
cellNumber++;
chart.Refresh();
}
// we have to populate the sheet with new values, now we need to create a series for it!
var columnsRange = dataSheet.UsedRange.Columns;
var rowsRange = dataSheet.UsedRange.Rows;
var columnCount = columnsRange.Columns.Count;
var rowCount = rowsRange.Rows.Count;
var lastColumnLetter = IntToLetters(columnCount);
var newSeries = sc.NewSeries();
newSeries.Name = series.name;
newSeries.XValues = "'Sheet1'!$A$1:$A$" + rowCount;
newSeries.Values = "'Sheet1'!$" + lastColumnLetter + "$1:$" + lastColumnLetter + "$" + rowCount;
newSeries.ChartType = series.seriesType;
chart.Refresh();
}