page 25

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml.Linq;
using PowerPoint = Microsoft.Office.Interop.PowerPoint;
using Office = Microsoft.Office.Core;

namespace VSTO
{
    public partial class ThisAddIn
    {
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create ppt document
            PowerPoint.Presentation ppt = this.Application.Presentations.Add();

            //Add a blank slide
            PowerPoint.Slide slide = ppt.Slides.Add(1, PowerPoint.PpSlideLayout.ppLayoutBlank);

            //Add chart
            PowerPoint.Shape shape = slide.Shapes.AddChart(Microsoft.Office.Core.XlChartType.xlColumnClustered, 100, 100, 500, 300);

            //Get the chart
            PowerPoint.Chart chart = slide.Shapes[1].Chart;

            //Create instance to excel workbook to work with chart datas
            PowerPoint.ChartData chartData = chart.ChartData;
            Microsoft.Office.Interop.Excel.Workbook dataWorkbook = (Microsoft.Office.Interop.Excel.Workbook)chartData.Workbook;

            //Get the worksheet of chart
            Microsoft.Office.Interop.Excel.Worksheet dataSheet = dataWorkbook.Worksheets[1];

            //Set the range of chart
            Microsoft.Office.Interop.Excel.Range range = dataSheet.Cells.get_Range("A1", "B5");

            //Set the data
            Microsoft.Office.Interop.Excel.ListObject table = dataSheet.ListObjects["Table1"];
            table.Resize(range);
            ((Microsoft.Office.Interop.Excel.Range)(dataSheet.Cells.get_Range("A2"))).Value = "January";
            ((Microsoft.Office.Interop.Excel.Range)(dataSheet.Cells.get_Range("A3"))).Value = "February";
            ((Microsoft.Office.Interop.Excel.Range)(dataSheet.Cells.get_Range("A4"))).Value = "March";
            ((Microsoft.Office.Interop.Excel.Range)(dataSheet.Cells.get_Range("A5"))).Value = "April";
            ((Microsoft.Office.Interop.Excel.Range)(dataSheet.Cells.get_Range("B2"))).Value = 100;
            ((Microsoft.Office.Interop.Excel.Range)(dataSheet.Cells.get_Range("B3"))).Value = 250;
            ((Microsoft.Office.Interop.Excel.Range)(dataSheet.Cells.get_Range("B4"))).Value = 300;
            ((Microsoft.Office.Interop.Excel.Range)(dataSheet.Cells.get_Range("B5"))).Value = 400;

            //Set the title of the chart
            chart.ChartTitle.Text = "Monthly Sales Report";

            //Save the file         
            ppt.SaveAs("AddedChart.pptx");
        }

        private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
        {
        }

        #region VSTO generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InternalStartup()
        {
            this.Startup += new System.EventHandler(ThisAddIn_Startup);
            this.Shutdown += new System.EventHandler(ThisAddIn_Shutdown);
        }
        
        #endregion
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Presentation;
using System.Drawing;
using Spire.Presentation.Charts;
using Spire.Presentation.Drawing;
using System.Data;

namespace Spire.Presentation
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create a presentation instance
            Presentation presentation = new Presentation();

            //Insert a column clustered chart
            IChart chart = presentation.Slides[0].Shapes.AppendChart(ChartType.ColumnClustered, new RectangleF(100,100,500,300));

            //Set chart title
            chart.ChartTitle.TextProperties.Text = "Monthly Sales Report";
            chart.ChartTitle.TextProperties.IsCentered = true;
            chart.ChartTitle.Height = 30;
            chart.HasTitle = true;

            //Create a datatable
            DataTable dataTable = new DataTable();
            dataTable.Columns.Add(new DataColumn("Month", Type.GetType("System.String")));
            dataTable.Columns.Add(new DataColumn("Sales", Type.GetType("System.Int32")));
            dataTable.Columns.Add(new DataColumn("Growth rate", Type.GetType("System.Decimal")));
            dataTable.Rows.Add("January", 200, 0.6);
            dataTable.Rows.Add("February", 250, 0.8);
            dataTable.Rows.Add("March", 300, 0.6);
            dataTable.Rows.Add("April", 150, 0.2);
           

            //Import data from datatable to chart data
            for (int c = 0; c < dataTable.Columns.Count; c++)
            {
                chart.ChartData[0, c].Text = dataTable.Columns[c].Caption;
            }
            for (int r = 0; r < dataTable.Rows.Count; r++)
            {
                object[] datas = dataTable.Rows[r].ItemArray;
                for (int c = 0; c < datas.Length; c++)
                {
                    chart.ChartData[r + 1, c].Value = datas[c];

                }
            }

            //Set series labels
            chart.Series.SeriesLabel = chart.ChartData["B1", "C1"];

            //Set categories labels    
            chart.Categories.CategoryLabels = chart.ChartData["A2", "A7"];

            //Assign data to series values
            chart.Series[0].Values = chart.ChartData["B2", "B7"];
            chart.Series[1].Values = chart.ChartData["C2", "C7"];

            //Change the chart type of serie 2 to line with markers
            chart.Series[1].Type = ChartType.LineMarkers;

            //Plot data of series 2 on the secondary axis
            chart.Series[1].UseSecondAxis = true;

            //Set the number format as percentage 
            chart.SecondaryValueAxis.NumberFormat = "0%";

            //Hide gridlinkes of secondary axis
            chart.SecondaryValueAxis.MajorGridTextLines.FillType = FillFormatType.None;

            //Set overlap
            chart.OverLap = -50;

            //Set gapwidth
            chart.GapWidth = 200;

            //Save and Launch
            presentation.SaveToFile("AddedChart.pptx", FileFormat.Pptx2010);
            System.Diagnostics.Process.Start("AddedChart.pptx");
        }
    }
}

AddChart.zip

Published in VSTO

Add text to slide

2017-08-23 05:56:22 Written by zaki zou

VSTO
Spire.Presentation
Download Sample Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml.Linq;
using PowerPoint = Microsoft.Office.Interop.PowerPoint;
using Office = Microsoft.Office.Core;
using System.Drawing;

namespace VSTO
{
    public partial class ThisAddIn
    {
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create empty presentation
            PowerPoint.Presentation ppt = this.Application.Presentations.Add();

            //Add a blank slide
            PowerPoint.Slide slide = ppt.Slides.Add(1, PowerPoint.PpSlideLayout.ppLayoutBlank);

            //Add a textbox
            PowerPoint.Shape shape = slide.Shapes.AddTextbox(Office.MsoTextOrientation.msoTextOrientationHorizontal, 100, 100, 300, 200);
            
            //Add text
            PowerPoint.TextRange textRange = shape.TextFrame.TextRange;
            textRange.Text = "Spire.Presentation for .NET";
           
            //Set text style
            textRange.Font.Color.RGB = 0x00CC3333;
            textRange.Font.Bold = Office.MsoTriState.msoTrue;
            textRange.Font.Size = 20;

            //Save the file
            ppt.SaveAs("AddedText.pptx");
        }

        private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
        {
        }

        #region VSTO generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InternalStartup()
        {
            this.Startup += new System.EventHandler(ThisAddIn_Startup);
            this.Shutdown += new System.EventHandler(ThisAddIn_Shutdown);
        }
        
        #endregion
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Presentation;
using System.Drawing;
using Spire.Presentation.Drawing;


namespace Spire.Presentation
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create ppt document
            Presentation ppt = new Presentation();
            
            //Add a shape
            IAutoShape shape = ppt.Slides[0].Shapes.AppendShape(ShapeType.Rectangle, new Rectangle(100, 100, 300, 200));

            //Make the shape invisible 
            shape.Fill.FillType = FillFormatType.None;
            shape.Line.FillType = FillFormatType.None;
            
            //Add text
            TextRange textRange=shape.TextFrame.TextRange;
            textRange.Text="Spire.Presentation for .NET";
            
            //Set text style           
            textRange.Format.Fill.FillType = FillFormatType.Solid;
            textRange.Format.Fill.SolidColor.Color = Color.Blue ;
            textRange.FontHeight=20;
            textRange.Format.IsBold = TriState.True;
            
            //Save and Launch
            ppt.SaveToFile("AddedText.pptx", FileFormat.Pptx2010);
            System.Diagnostics.Process.Start("AddedText.pptx");
            
        }
    }
}

AddText.zip

Published in VSTO

Add table to slide

2017-08-23 05:53:43 Written by zaki zou

VSTO
Spire.Presentation
Download Sample Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml.Linq;
using PowerPoint = Microsoft.Office.Interop.PowerPoint;
using Office = Microsoft.Office.Core;

namespace VSTO
{
    public partial class ThisAddIn
    {
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create empty presentation
            PowerPoint.Presentation ppt = this.Application.Presentations.Add();

            //Add a blank slide
            PowerPoint.Slide slide = ppt.Slides.Add(1, PowerPoint.PpSlideLayout.ppLayoutBlank);

            //Add table to slide
            PowerPoint.Shape shape = slide.Shapes.AddTable(6, 6, 0, 0, 800, 400);
            PowerPoint.Table table = shape.Table;

            //Loop the table to fill text
            for (int i = 1; i <= table.Rows.Count; i++)
            {
                for (int j = 1; j <= table.Columns.Count; j++)
                {                    
                    PowerPoint.TextFrame tf = table.Cell(i, j).Shape.TextFrame;
                    tf.TextRange.Text = "Row" + i.ToString() + "Col" + j.ToString();
                    tf.TextRange.ParagraphFormat.Alignment = PowerPoint.PpParagraphAlignment.ppAlignCenter;
                }
            }

            //Save the file
            ppt.SaveAs("Table.pptx");
        }

        private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
        {
        }

        #region VSTO generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InternalStartup()
        {
            this.Startup += new System.EventHandler(ThisAddIn_Startup);
            this.Shutdown += new System.EventHandler(ThisAddIn_Shutdown);
        }
        
        #endregion
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Presentation;

namespace Spire.Presentation
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create PPT document
            Presentation ppt = new Presentation();
            
            //Add new table to PPT
            Double[] widths = new double[] {100,100,100,100,100,100};
            Double[] heights = new double[] { 50,50,50,50,50,50 };
            ITable table = ppt.Slides[0].Shapes.AppendTable(0,0, widths, heights);

            //Set the style of table
            table.StylePreset = TableStylePreset.LightStyle1Accent2;

            //Loop the table to fill data
            for (int i = 0; i < heights.Length; i++)
                for (int j = 0; j < widths.Length; j++)
                {                   
                    table[i, j].TextFrame.Text = "Row"+i.ToString()+"Col"+j.ToString();                   
                    table[j, i].TextFrame.Paragraphs[0].TextRanges[0].LatinFont = new TextFont("Arial Narrow");
                    table[i, j].TextFrame.Paragraphs[0].Alignment = TextAlignmentType.Center;
                }

            //Save and Launch
            ppt.SaveToFile("Table.pptx", FileFormat.Pptx2010);
            System.Diagnostics.Process.Start("Table.pptx");

        }
    }
}

AddTable.zip

Published in VSTO

Add shapes to slide

2017-08-23 05:50:57 Written by zaki zou

VSTO
Spire.Presentation
Download Sample Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml.Linq;
using PowerPoint = Microsoft.Office.Interop.PowerPoint;
using Office = Microsoft.Office.Core;

namespace VSTO
{
    public partial class ThisAddIn
    {
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create ppt document
            PowerPoint.Presentation ppt = Globals.ThisAddIn.Application.Presentations.Add();

            //Add a blank slide
            PowerPoint.Slide slide = ppt.Slides.Add(1, PowerPoint.PpSlideLayout.ppLayoutBlank);

            //Add rectangle shape
            slide.Shapes.AddShape(Office.MsoAutoShapeType.msoShapeRectangle, 50, 100, 100, 100);

            //Add arrow shape
            slide.Shapes.AddShape(Office.MsoAutoShapeType.msoShapeRightArrow, 200, 100, 100, 100);

            //Add triangle shape
            slide.Shapes.AddShape(Office.MsoAutoShapeType.msoShapeRightTriangle, 350, 100, 100, 100);

            //Save the file
            ppt.SaveAs("Shape.pptx");
        }

        private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
        {
        }

        #region VSTO generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InternalStartup()
        {
            this.Startup += new System.EventHandler(ThisAddIn_Startup);
            this.Shutdown += new System.EventHandler(ThisAddIn_Shutdown);
        }
        
        #endregion
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Presentation;
using System.Drawing;

namespace Spire.Presentation
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create ppt document
            Presentation ppt = new Presentation();
            
            //Append rectangle shape
            IAutoShape shape = ppt.Slides[0].Shapes.AppendShape(ShapeType.Rectangle, new RectangleF(50,100,100,100));

            //Append arrow shape
            shape = ppt.Slides[0].Shapes.AppendShape(ShapeType.RightArrow, new RectangleF(200, 100, 100, 100));

            //Append triangle shape
            shape = ppt.Slides[0].Shapes.AppendShape(ShapeType.RightTriangle, new RectangleF(350, 100, 100, 100));

            //Save and Launch
            ppt.SaveToFile("Shape.pptx",FileFormat.Pptx2010);
            System.Diagnostics.Process.Start("Shape.pptx");

        }
    }
}

AddShapes.zip

Published in VSTO

Add image to slide master

2017-08-23 05:46:17 Written by zaki zou

VSTO
Spire.Presentation
Download Sample Code

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Xml.Linq;
using PowerPoint = Microsoft.Office.Interop.PowerPoint;
using Office = Microsoft.Office.Core;

namespace VSTO
{
    public partial class ThisAddIn
    {
        private void ThisAddIn_Startup(object sender, System.EventArgs e)
        {
            //Create empty presentation
            PowerPoint.Presentation ppt = this.Application.Presentations.Add();

            //Add a blank slide
            PowerPoint.Slide slide = ppt.Slides.Add(1, PowerPoint.PpSlideLayout.ppLayoutBlank);

            //Get the master
            PowerPoint.Master master = ppt.SlideMaster;

            //Insert an image to slide master
            master.Shapes.AddPicture("../../image.gif", Office.MsoTriState.msoTriStateMixed, Office.MsoTriState.msoTriStateMixed, 700, 50, 247, 70);

            //Add a blank slide
            ppt.Slides.Add(1, PowerPoint.PpSlideLayout.ppLayoutBlank);

            //Save the file
            ppt.SaveAs("MasterImage.pptx");
        }

        private void ThisAddIn_Shutdown(object sender, System.EventArgs e)
        {
        }

        #region VSTO generated code

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InternalStartup()
        {
            this.Startup += new System.EventHandler(ThisAddIn_Startup);
            this.Shutdown += new System.EventHandler(ThisAddIn_Shutdown);
        }
        
        #endregion
    }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Spire.Presentation;
using System.Drawing;
using System.IO;
using Spire.Presentation.Drawing;

namespace Spire.Presentation
{
    class Program
    {
        static void Main(string[] args)
        {
            //Create presentation
            Presentation ppt = new Presentation();

            //Get the slide
            ISlide slide = ppt.Slides[0];

            //Get the master 
            IMasterSlide master = ppt.Masters[0];

            //Insert an image to slide master
            string imageFile = "../../image.gif";           
            IEmbedImage image = master.Shapes.AppendEmbedImage(ShapeType.Rectangle, imageFile, new Rectangle(450,50,247,70));
            image.Line.FillFormat.FillType = FillFormatType.None;
            
            //Add a blank slide
            ppt.Slides.Append();

            //Save and Launch
            ppt.SaveToFile("MasterImage.pptx", FileFormat.Pptx2010);
            System.Diagnostics.Process.Start("MasterImage.pptx");
            
        }
    }
}

AddImageToMaster.zip

Published in VSTO