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

(1) Share

Report

Posted on by egsameera

134

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?

I have the same question (0)

All responses (6)

Answers (2)

Mohamed Amine Mahmoudi 26,449 Super User 2025 Season 2 on at

Like (1)

Report

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

Was this reply helpful? Yes No
egsameera 134 on at

Like (1)

Report

Hi Mohamed,

It gives below errors when used the verified answer.

Declaration

Code

Error

Regards,

Gihan Sameera

Was this reply helpful? Yes No
Suggested answer

Komi Siabi 13,122 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
CU02090611-0 4 on at

Like (1)

Report

Hi Komi,

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

Regards,

Gihan

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,996 Most Valuable Professional on at

Like (1)

Report

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(....

Was this reply helpful? Yes No
Verified answer

egsameera 134 on at

Like (1)

Report

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

Was this reply helpful? Yes No