How do i add image to excel with x++

Dynamics 365 for Finance and Operations/AX Developer Forum
1

Hi,

i want to add image to excel with x++ ax 2009. how do i do this?

2

already discussed before , please check below link

dynamicsuser.net/…/16803

3

Thanks Kunal,
I examined the link. Creating a new Excel document. But I have to open a document that you want to insert a picture into it. Can you help with this?

4

comApplication.visible(true)

try if it is working or not

5

at the end of the code

instead of

//Force app to quit
comWorkBook.saveas(“c:\temp\hello.xls”);
comWorkBooks.close();
comApplication.quit();

you can try

//Force app to quit
comWorkBook.saveas(“c:\temp\hello.xls”);
comWorkBooks.close();
comApplication.visible(true);

6

Hi again Kunal;

I have an xls files as templates . I 'm trying to add an image to determine a location into the open this file . Xls file in this example creates a new form. I want to use the saved XLS file in the existing template . You can open and save data into the existing xls file using the following method . But I can not add photos …
…
SysExcelApplication application;
SysExcelWorkBooks workbooks;
SysExcelWorkBook workbook;
SysExcelWorksheets worksheets;
sysExcelWorksheet worksheet;
SysExcelCells cells;
SysExcelCell cell;
;

application = SysExcelApplication::construct();
workbooks = application.workbooks();
workbooks.open(“c:\test\template.xls”);

…