News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics NAV (Archived) Export to excel using ...

Microsoft Dynamics NAV (Archived)

Export to excel using Excel buffer(Image)

(0) Share

Report

Report

Posted on by Community Member Microsoft Employee

Hi,

Using Excel buffer, I want to Export a Picture to a excel. (For ex:CompInfo.Picture) using dotnet variable.

Suggestion Please..

Thank you.

*This post is locked for comments

All responses Img

All responses (3)

Answers Img

Answers (0)

Community Member Microsoft Employee on at

Like (0)

Report

RE: Export to excel using Excel buffer(Image)

You can check available assembly list in .NET type. You can explore the package Microsoft.Office.Tools.Excel.
Community Member Microsoft Employee on at

Like (0)

Report

RE: Export to excel using Excel buffer(Image)

Thanks Paolo.

Like, with automation based your inputs should be working fine ,But I want to try with 'DotNet' type.

Thanks
Suggested answer

Community Member Microsoft Employee on at

Like (1)

Report

RE: Export to excel using Excel buffer(Image)

i have never tryed but in this post seem it can be done

forum.mibuso.com/.../exporting-picture-object-to-excel

The Function CreateSheet() in "Excel Buffer" table generates the Shape.

SetPathToPicture(PicturePath:Text[1024]) Here we store in a global variable the Path

FilePathAndName := PicturePath;

in function CreateSheet() we check the Value of the variable FilePathAndName and check if folder and file exist. if both is true, we import the Picture in our shape.

CreateSheet()

//New Code +++++++

if (FilePathAndName <> '') and (Exists(FilePathAndName)) then

XlWrkSht.Shapes.AddPicture(FilePathAndName, 1, 1, 20, 20, 100, 100);

//New Code ------------

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 292,494 Super User 2025 Season 1

#2

Martin Dráb 231,309 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans