Wednesday, 23 August 2017 06:04
Replace text in slide
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) { //Open ppt document PowerPoint.Presentation ppt = Application.Presentations.Open("../../Data/Sample.pptx"); //Loop through all slides and shapes foreach (PowerPoint.Slide slide in ppt.Slides) { foreach (PowerPoint.Shape shape in slide.Shapes) { //Replace the specified text shape.TextFrame.TextRange.Replace("Spire", "Replacement", 0, Office.MsoTriState.msoFalse, Office.MsoTriState.msoFalse); } } //Save the file ppt.SaveAs("Replace.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 } }
Published in
VSTO
Wednesday, 23 August 2017 06:01
Print presentation
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) { //Open ppt document PowerPoint.Presentation ppt = Application.Presentations.Open("../../Sample.pptx"); //Fit to page ppt.PrintOptions.FitToPage = Office.MsoTriState.msoTrue; //Print ppt.PrintOut(1, ppt.Slides.Count, "", 0); } 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 } }
Published in
VSTO
Wednesday, 23 August 2017 05:58
Insert charts in slide
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 } }
Published in
VSTO
Wednesday, 23 August 2017 05:56
Add text to slide
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 } }
Published in
VSTO
Wednesday, 23 August 2017 05:53
Add table to slide
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 } }
Published in
VSTO
Wednesday, 23 August 2017 05:50
Add shapes to slide
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 } }
Published in
VSTO
Wednesday, 23 August 2017 05:46
Add image to slide master
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 } }
Published in
VSTO
Tuesday, 22 August 2017 06:44
Set page margin and size
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Xml.Linq; using Word = Microsoft.Office.Interop.Word; using Office = Microsoft.Office.Core; using Microsoft.Office.Tools.Word; using System.Drawing; namespace VSTO { public partial class ThisAddIn { private void ThisAddIn_Startup(object sender, System.EventArgs e) { //Open document Word.Application wordApp = Application; wordApp.Documents.Open("../../Sample.docx"); //Set Page Margins Word.Range range = wordApp.Application.ActiveDocument.Range(1, 2); range.PageSetup.TopMargin = 12.0f; range.PageSetup.BottomMargin = 12.0f; range.PageSetup.LeftMargin = 12.0f; range.PageSetup.RightMargin = 12.0f; //Set Page Orientation range.PageSetup.Orientation = Word.WdOrientation.wdOrientLandscape; //Set Page Size range.PageSetup.PaperSize = Word.WdPaperSize.wdPaperA4; } 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 } }
Published in
VSTO
Tuesday, 22 August 2017 06:41
Set bullet style in word document
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Xml.Linq; using Word = Microsoft.Office.Interop.Word; using Office = Microsoft.Office.Core; using Microsoft.Office.Tools.Word; namespace VSTO { public partial class ThisAddIn { private void ThisAddIn_Startup(object sender, System.EventArgs e) { //Open document Microsoft.Office.Interop.Word.Application wordApp = Application; wordApp.Documents.Open("../../Word.docx"); //Get the count of paragraphs int count = this.Application.ActiveDocument.Paragraphs.Count; //Set Bullet Style for (int i = 1; i <= this.Application.ActiveDocument.Paragraphs.Count; i++) { Word.Range range = this.Application.ActiveDocument.Paragraphs[i].Range; Word.ListFormat listFormat = range.ListFormat; listFormat.ApplyBulletDefault(); } } 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 } }
Tuesday, 22 August 2017 06:38
Protect word document
using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Xml.Linq; using Word = Microsoft.Office.Interop.Word; using Office = Microsoft.Office.Core; using Microsoft.Office.Tools.Word; namespace VSTO { public partial class ThisAddIn { private void ThisAddIn_Startup(object sender, System.EventArgs e) { //Open document Microsoft.Office.Interop.Word.Application wordApp = Application; wordApp.Documents.Open("../../Sample.docx"); //Protect the document object noReset = false; object password = "E-iceblue"; object useIRM = false; object enforceStyleLock = false; this.Application.ActiveDocument.Protect(Word.WdProtectionType.wdAllowOnlyReading, ref noReset, ref password, ref useIRM, ref enforceStyleLock); } 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 } }