Edi Yanto (何 萬 新)

The Excel output can’t showing the image (even after you save and send to another person or open it at different notebook), but it is showing only small red color empty cross written ‘An Image’.  Why???
As many of you know or have noticed, our Excel output for all flavors of BIP/XMLP is not true binary Excel output. It’s actually XHTML with the mime type set  to get Excel to open it. Understand its not Excel HTML but XHTML.  So, there is going to be a limit in what you can generate in the Excel output.

Where are the images in the Excel?
* You need to set a couple of properties to allow use to access them and you need to be connected to the network to get the images.

With standalone 10.1.3.4 the Excel output is actually MHTML where we can embed the images directly in the HTML file so you don’t need the properties set.

* In the “Web” Tab of the the image properties.
Paste an image in the template where you would like your image to be displayed in the output. Double click the image. In the “Web” Tab of the the image properties write this:

url:{concat(CP_IMAGE_LOC,’/’,’logo.gif’)}

where CP_IMAGE_LOC contains your unix directory path where my logo.gif file resides. CP_IMAGE_LOC is a placeholder in your rdf and hence is part of my XML output.
OR you can set the like this:

url:{‘${OA_MEDIA}/logo.gif’}

Our Excel is not true Excel and it has a limited set of functionality but for many users its enough just to get the data out into Excel.