web

You’re offline. This is a read only version of the page.

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

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

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (0)

Suggested answer

Community Member on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Paolo.

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

Thanks

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

You can check available assembly list in .NET type. You can explore the package Microsoft.Office.Tools.Excel.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

#1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans