public static void Run() { //ExStart:SupportForSwitchingRowsAndColumns string dataDir = RunExamples.GetDataDir_Charts(); using (Presentation pres = new Presentation(dataDir + "Test.pptx")) { IChart chart = pres.Slides[0].Shapes.AddChart(ChartType.ClusteredColumn, 100, 100, 400, 300); IChartSeries[] series = new IChartSeries[chart.ChartData.Series.Count]; chart.ChartData.Series.CopyTo(series, 0); IChartDataCell[] categoriesCells = new IChartDataCell[chart.ChartData.Categories.Count]; for (int i = 0; i < chart.ChartData.Categories.Count; i++) { categoriesCells[i] = chart.ChartData.Categories[i].AsCell; } IChartDataCell[] seriesCells = new IChartDataCell[chart.ChartData.Series.Count]; for (int i = 0; i < chart.ChartData.Series.Count; i++) { seriesCells[i] = chart.ChartData.Series[i].Name.AsCells[0]; } chart.ChartData.SwitchRowColumn(); pres.Save(RunExamples.OutPath + "Test_out.pptx", SaveFormat.Pptx); //ExEnd:SupportForSwitchingRowsAndColumns } }
public static void Run() { string outpptxFile = Path.Combine(RunExamples.OutPath, "ChartDataCell_Formulas_out.pptx"); using (Presentation presentation = new Presentation()) { IChart chart = presentation.Slides[0].Shapes.AddChart(ChartType.ClusteredColumn, 150, 150, 500, 300); IChartDataWorkbook workbook = chart.ChartData.ChartDataWorkbook; IChartDataCell cell1 = workbook.GetCell(0, "B2"); cell1.Formula = "1 + SUM(F2:H5)"; IChartDataCell cell2 = workbook.GetCell(0, "C2"); cell2.R1C1Formula = "MAX(R2C6:R5C8) / 3"; presentation.Save(outpptxFile, SaveFormat.Pptx); } }
public static void Run() { //ExStart:SwitchChartRowColumns // The path to the documents directory. string dataDir = RunExamples.GetDataDir_Charts(); // Creating empty presentation using (Presentation pres = new Presentation()) { IChart chart = pres.Slides[0].Shapes.AddChart(ChartType.ClusteredColumn, 100, 100, 400, 300); //Add data IChartSeries[] series = new IChartSeries[chart.ChartData.Series.Count]; chart.ChartData.Series.CopyTo(series, 0); IChartDataCell[] categoriesCells = new IChartDataCell[chart.ChartData.Categories.Count]; for (int i = 0; i < chart.ChartData.Categories.Count; i++) { categoriesCells[i] = chart.ChartData.Categories[i].AsCell; } IChartDataCell[] seriesCells = new IChartDataCell[chart.ChartData.Series.Count]; for (int i = 0; i < chart.ChartData.Series.Count; i++) { seriesCells[i] = chart.ChartData.Series[i].Name.AsCells[0]; } //Switching rows and columns chart.ChartData.SwitchRowColumn(); // Saving presentation pres.Save(RunExamples.OutPath + "SwitchChartRowColumns_out.pptx", SaveFormat.Pptx); //ExEnd:SwitchChartRowColumns } }