Transformation img to excel file

[chau1995]

Dear everyone,

I have a big problem, that is using transformation data (include itab and img) to excel file (at local computer) with two options:

1.Store image path and display img to excel

2.Store binary and show img to excel

My template is same as:

<picture> show here

<itab> with more field and item will show below <picture>

Please help me in this problem

Note that: don't use xlsx_workbench or abap2xlsx.....

Thanks so much...

[SimoneMilesi]

So what are you using? OLE?

Try to explain what are you doing and which steps you took, so we can help you.

[DoanManhQuynh]

you should use cl_xlsx_document, it quite simple to implement.

[chau1995]

But in few case, my excel template is very complex, and i want to manage it using xslt code, so i can use transformation

But with image, i don't know how to do it. I tried to convert to xstring to pass it into xslt and using transformation but it not work!!!

[chau1995]

Step 1. I create a structure from DDIC

Step 2: I create template with xslt

Step 3: Fill data to this structure which was created before

Step 4: Call transformation and pass this data to it.
But with image, assume i downloaded it at local computer, i want to read path to show image in this excel, i don't know how to do it.

[DoanManhQuynh]

transformation only support simple excel which have text and format, its not support shape, image.. so if you use transformation only you cant achive it. however, cl_xslt_documen can.

xlsx file just a compressed archive of XML text documents ( you can see it by right click and unzip ) and cl_xlsx_document can handle those xml documents. have a look at package S_OOXML_CORE. if it available in your system, look at class CL_SALV_BS_OFFICE2007_BASE to see how it manage to create a excel with that class.

[chau1995]

Thanks, i will check it in my system