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
}
}
Tuesday, 22 August 2017 06:34
Print 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)
{
Microsoft.Office.Interop.Word.Application wordApp = Application;
wordApp.Documents.Open("../../Sample.docx");
this.Application.ActiveDocument.PrintOut();
}
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:30
Merge documents
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
Word.Application wordApp = Application;
wordApp.Documents.Open("../../Sample.docx");
wordApp.Selection.WholeStory();
wordApp.Selection.EndOf();
wordApp.Selection.Range.InsertBreak();
//Merge the file
wordApp.Selection.InsertFile("../../Table.docx");
}
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:24
Insert image 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
Word.Application wordApp = Application;
wordApp.Documents.Open("../../Blank.docx");
//Add picture
this.Application.Selection.InlineShapes.AddPicture("../../image.jpg");
}
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:22
Insert header and footer
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
Word.Application wordApp = Application;
wordApp.Documents.Open("../../Sample.docx");
//Add Header
foreach (Word.Section section in this.Application.ActiveDocument.Sections)
{
Word.Range header = section.Headers[Word.WdHeaderFooterIndex.wdHeaderFooterPrimary].Range;
header.Fields.Add(header, Word.WdFieldType.wdFieldPage);
header.Text = "Spire.doc";
header.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphRight;
}
//Add Footer
foreach (Word.Section wordSection in this.Application.ActiveDocument.Sections)
{
Word.Range footer = wordSection.Footers[Word.WdHeaderFooterIndex.wdHeaderFooterPrimary].Range;
footer.Font.Size = 14;
footer.Text = "E-iceblue";
footer.Font.ColorIndex = Word.WdColorIndex.wdDarkBlue;
}
}
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
}
}