using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?Aspose.Cells;
using?Aspose.Slides;
using?System.IO;
using?Aspose.Cells.Charts;
using?System.Drawing;

namespace?Rap.Report.Slides
{
????static?class?ChartUtils
????{
????????private?static?Random?random?=?new?Random（Environment.TickCount）;

????????///?替換chart數據
????????///?

????????///?替換chart數據
????????///?

????????///?tle“>chart標題
????????///?數據源
????????///?模板名稱
????????///?chart名
????????///?ppt頁碼
????????public?static?void?GetChart（string?charttitle?IListject[]>?list?Slide?slide?string?chartName）
????????{
????????????Shape?shape?=?slide.FindShape（chartName）;
????????????Oleobjectframe?ole?=?（Oleobjectframe）shape;
????????????if?（ole?!=?null）
????????????{
????????????????Workbook?wb?=?new?Workbook（）;
????????????????var?ms?=?new?MemoryStream（ole.objectData）;
????????????????wb.Open（ms）;
????????????????int?chartindex?=?0;
????????????????int?sheetidx?=?1;
????????????????Chart?chart?=?null;
????????????????if?（wb.Worksheets[1].Charts.Count?>?0）
????????????????{
????????????????????chartindex?=?1;
????????????????????sheetidx?=?0;
????????????????}
????????????????chart?=?wb.Worksheets[chartindex].Charts[0];
????????????????if?（chart.Shapes.Count?>?0）
????????????????{
????????????????????chart.Shapes.RemoveAt（0）;
????????????????}
????????????????chart.title.Text?=?charttitle;
????????????????Worksheet?sheet?=?wb.Worksheets[sheetidx];
????????????????ExcelUtils.SetChartData（sheet?list）;
????????????????//設置chart取值范圍
????????????????for?（int?i?=?0;?i?????????????????{
????????????????????chart.NSeries[i].XValues?=?string.Format（“{0}!{1}:{2}“?sheet.Name“A2“?“A“+list.Count.ToString（））;
????????????????????chart.NSeries[i].Name?=?sheet.Cells[0?i?+?1].Value.ToString（）;
????????????????????chart.NSeries[i].Values?=?string.Format（“{0}!{1}:{2}“?sheet.Name?ExcelUtils.COLUMNS[i?+?1]?+?“2“
????????????????????????ExcelUtils.COLUMNS[i?+?1]?+?list.Count.ToString（））;
????????????????????chart.NSeries[i].IsColorVaried?=?true;
????????????????????
????????????????}
????????????????SetChartstyle（chart）;
????????????????wb.CalculateFormula（）;
????????????????ms?=?wb.SaveToStream（）;
????????????????ole.objectData?=?ms.ToArray（）;
????????????????Bitmap?bitmap?=?chart.ToImage（）;
????????????????Aspose.Slides.Picture?pic?=?new?Aspose.Slides.Picture（slide.Parent?bitmap）;
????????????????ole.PictureId?=?slide.Parent.Pictures.Add（pic）;
????????????????//bitmap.Save（“..\\..\\PPTFiles\\Template\\“?+?random.Next（）?+?“.jpg“）;
????????????????//wb.Save（@“..\..\PPTFiles\“?+?random.Next（）?+?“.xls“?Aspose.Cells.SaveFormat.Excel97To2003）;
????????????}
????????}

????????///?設置chart樣式
????????///?