How to Convert Excel Worksheets to Images in .NET Core Word document?

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 convert Excel worksheets to images and insert them into a Word document using C#.

To achieve this, convert Excel worksheets to images using the Syncfusion® Excel Library (XlsIO), and then insert those images into a Word document using the Syncfusion® Word Library (DocIO).

Steps to convert Excel worksheets to images and insert them into a 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.
   
   
   
   Install the Syncfusion.XlsIORenderer.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.XlsIO;
using Syncfusion.XlsIORenderer;
using Syncfusion.DocIO;
using Syncfusion.DocIO.DLS;

4. Use the following code example to convert Excel worksheets to images and insert them into a Word document.
   C#

// Initialize XlsIO renderer
using (ExcelEngine excelEngine = new ExcelEngine())
{
    IApplication application = excelEngine.Excel;
    // Initialize the XlsIORenderer (required for ConvertToImage)
    application.XlsIORenderer = new XlsIORenderer();
    // Open the Excel file
    IWorkbook workbook = application.Workbooks.Open(Path.GetFullPath(@"Data/Template.xlsx"));
    // Create the Word document
    using (WordDocument document = new WordDocument())
    {
        for (int i = 0; i < workbook.Worksheets.Count; i++)
        {
            IWorksheet worksheet = workbook.Worksheets[i];
            // Convert used range of worksheet to image
            using (MemoryStream imageStream = new MemoryStream())
            {
                worksheet.ConvertToImage(worksheet.UsedRange, imageStream);
                imageStream.Position = 0;
                // Add a new section for each worksheet
                IWSection section = document.AddSection();
                section.PageSetup.Orientation = PageOrientation.Landscape;
                IWParagraph paragraph = section.AddParagraph();
                // Insert the Excel image into the paragraph
                IWPicture picture = paragraph.AppendPicture(imageStream);
                // Optionally set image dimensions
                picture.Width = 600;
                picture.Height = 380;
            }
        }
        // Save the Word document
        document.Save(Path.GetFullPath(@"Output/Result.docx"), FormatType.Docx);
    }
}

You can download a complete working sample to convert Excel worksheets to images and insert them into a 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 the Word documents, and most importantly, the PDF and Image conversions with code examples.

See Also

• Working with images
• Excel to image conversion

Conclusion

I hope you enjoyed learning about how to convert Excel worksheets to images and insert them into a Word document in a .NET Core Word document.

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 with 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!