add picture in excel using epplus

(0) Share

Report

Posted on by Tony Mok

577

I have a container field in the table and I would like to add in excel.

I tried below code

if(table1.Image1 != conNull())
{
    System.Drawing.Image image1 = table1.Image1;
    var excelImage = worksheet.Drawings.AddPicture("image1",image1);
    excelImage.SetPosition(20, 0, 5, 0);
}

and The type of System.Drawing.Image does not match with container.

How can I add picture in excel using epplus

I have the same question (0)

All responses (6)

Answers (1)

André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi Tony,

Can you tell if and how this question is related to Dynamics 365? What is EPPlus?

Was this reply helpful? Yes No
Tony Mok 577 on at

Like (0)

Report

I need to export the excel with picture added and EPPlus is a .NET library that reads and writes Excel 2007/2010/2013 files using the Open Office Xml format (xlsx)

Was this reply helpful? Yes No
Suggested answer

André Arnaud de Cal... 301,069 Super User 2025 Season 2 on at

Like (0)

Report

Hi Tony,

Can you answer the question if and how it is related to Dynamics 365? Probably, there is also a forum for EPPlus or you can contact the vendor of this solution for additional help.

Was this reply helpful? Yes No
Verified answer

Sergei Minozhenko 23,093 on at

Like (2)

Report

Hi Tony,

You are trying to assign x++ container type object to .net Image object. And it can't be done explicitly. Try to convert container to stream and create Image class from the stream.

Something like this:

System.Drawing.Image image = System.Drawing.Image.FromStream(Binary::constructFromContainer(your_container).getMemoryStream());

Was this reply helpful? Yes No
Blue Wang on at

Like (1)

Report
Hi Tony,

What is the object table1.Image1?

Add namespaces.

using System.Drawing; using OfficeOpenXml.Drawing;

An example about get the image from disk.

https://riptutorial.com/epplus/example/26414/add-an-image-to-a-sheet

Was this reply helpful? Yes No
Tony Mok 577 on at

Like (0)

Report
Thank you. Sergei Minozhenko, Blue Wang
System.IO.MemoryStream MemoryStream = Binary::constructFromContainer(table1.Image1).getMemoryStream(); MemoryStream.Position = 0; System.Drawing.Image image1 = System.Drawing.Image::FromStream(MemoryStream);

Was this reply helpful? Yes No

Join the conversation

Community site session details

add picture in excel using epplus

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

add picture in excel using epplus

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates