How to Insert Excel, Word, PowerPoint & PDF as OLE in .Net Core Word?

Syncfusion; Essential; DocIO is a .NET Word library used to create, read, edit, and convert Word documents programmatically without Microsoft Word or interop dependencies. Using this library, you can insert Excel, Word, PowerPoint, and PDF documents as OLE objects in the Word document using C#.

Steps to insert Excel, Word, PowerPoint, and PDF documents as OLE objects in the Word document:

1. Create a new .NET Core console application project.
   
   
2. Install the Syncfusion.DocIO.Net.Core NuGet package as a reference to your project from NuGet.org.
   
   

3. Include the following namespaces in the Program.cs file
   C#

using Syncfusion.DocIO.DLS;
using Syncfusion.DocIO;

4. Use the following code example to insert Excel, Word, PowerPoint, and PDF documents as OLE objects in the Word document.
   C#

// Create a new Word document.
using (WordDocument document = new WordDocument())
{
   // Add a new section to the document.
   IWSection section = document.AddSection();
   // Add different types of documents as OLE objects.
   AddOleObject(document, section, "Data/Template.pdf", "Data/pdf.png", OleObjectType.AdobeAcrobatDocument);
   AddOleObject(document, section, "Data/Template.xlsx", "Data/excel.png", OleObjectType.ExcelWorksheet);
   AddOleObject(document, section, "Data/Adventure.docx", "Data/word.png", OleObjectType.WordDocument);
   AddOleObject(document, section, "Data/Sample.pptx", "Data/powerpoint.png", OleObjectType.PowerPointPresentation);
   // Save the Word document to a file.
   using (FileStream outputStream = new FileStream(Path.GetFullPath(@"Output/Result.docx"), FileMode.Create, FileAccess.ReadWrite, FileShare.ReadWrite))
   {
       document.Save(outputStream, FormatType.Docx);
   }
}

5. Use the following code example to add an OLE object to the Word document.
   C#

private static void AddOleObject(WordDocument document, IWSection section, string filePath, string imagePath, OleObjectType oleType)
{
   // Add a new paragraph to the section.
   IWParagraph paragraph = section.AddParagraph();

   // Open the file to be embedded as an OLE object.
   using (FileStream fileStream = new FileStream(Path.GetFullPath(filePath), FileMode.Open))
   using (FileStream imageStream = new FileStream(Path.GetFullPath(imagePath), FileMode.Open, FileAccess.ReadWrite))
   {
       // Load the image as a representation of the OLE object.
       WPicture picture = new WPicture(document);
       picture.LoadImage(imageStream);

       // Append the OLE object to the paragraph.
       WOleObject oleObject = paragraph.AppendOleObject(fileStream, picture, oleType);
       paragraph.AppendText("\n");

       // Set the display size of the OLE object.
       oleObject.OlePicture.Height = 80;
       oleObject.OlePicture.Width = 100;
   }
}

You can download a complete working sample to insert Excel, Word, PowerPoint, and PDF documents as OLE objects in the Word document from GitHub.

Take a moment to peruse the documentation where you can find basic Word document processing options along with features like mail merge, merge, split, and compare Word documents, find and replace text in the Word document, protect Word documents, and most importantly, the PDF and Image conversions with code examples.

See Also

• Working with OLE Objects

Conclusion

I hope you enjoyed learning about how to insert excel, word, powerpoint & Pdf as Ole in .Net Core Word.

You can refer to our ASP.NET Core DocIO feature tour page to know about its other groundbreaking feature representations and documentation, and how to quickly get started for configuration specifications. You can also explore our ASP.NET Core DocIO example to understand how to create and manipulate data.

For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our other controls.

If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forums, Direct-Trac, or feedback portal. We are always happy to assist you!