Excel Limitations on Images in Oracle Apps

Posted by: Edi Yanto on: May 23, 2009

In: Oracle
Comment!

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.

Base image URI	html-image-baseuri	Base URI which is inserted into the src attribute of the image tag before the image file name. This works only when the image is embedded in the template.
Image file directory	html-image-dir	Enter the directory for XML Publisher to store the image files that are embedded in the template.

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.

Easy AdSenser by Unreal

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

Share on Facebook