How to get the company logo for a customized excel export using X++

(1) Share

Report

Posted on by egsameera

154

I have created a personalized excel report using "OfficeOpenXml" in D365F&O. I would like to have the company logo in it. Is there anyone that could assist with this?

All responses (6)

Answers (2)

Sort by

Mohamed Amine Mahmoudi 26,826 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

Hi,

I hope this can help you.

https://community.dynamics.com/forums/thread/details/?threadid=044d0f8b-8632-488f-baf5-30f4d899c748

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

Best regards,

Mohamed Amine MAHMOUDI
egsameera 154 on at

Like (1)

Report
Copy link

Link copied!

Hi Mohamed,

It gives below errors when used the verified answer.

Declaration

Code

Error

Regards,

Gihan Sameera
Suggested answer

Komi Siabi 13,253 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You need to add the appropriate package to your project.

https://learn.microsoft.com/en-us/answers/questions/1338964/image-could-not-be-found-in-the-namespace-system-d
CU02090611-0 4 on at

Like (1)

Report
Copy link

Link copied!

Hi Komi,

When click on the "Manage NuGet packages" it says unsupported. And after that the option is grayed out.

Regards,

Gihan
Verified answer

Martin Dráb 241,467 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

You can't manage NuGet packages on X++ projects - if you need NuGet, you need a C# library. But I don't think you need any. System and System.Drawing namespaces are a part of .NET Framework.

A bug in your code is that you're calling FromFile as it was an instance method, but it's a static one, therefore it must be Image::FromFile(....
Verified answer

egsameera 154 on at

Like (1)

Report
Copy link

Link copied!

Hi Martin,

Thank you so much for the explanation and it worked.

Below is the sample code.

private void setCompanyImage(ExcelWorksheet _WorkSheet)
{
   System.Drawing.Image image = System.Drawing.Image::FromStream(Binary::constructFromContainer(FormLetter::companyLogo()).getMemoryStream());

   var excelImage = _WorkSheet.Drawings.AddPicture("CompanyLogo", image);
   excelImage.SetPosition(6, 2, 5, 2);
   excelImage.SetSize(15);
}

Cheers,

Gihan