Home » Developer & Programmer » Forms » Positioning an image on XLS file using ole2 (Forms 6.0.8)
Positioning an image on XLS file using ole2 [message #616383] Mon, 16 June 2014 08:11
Messages: 2
Registered: June 2014
Location: Brasil
Junior Member

I need to insert an image on a new XLS file (what I've already done), but I have to define the position where I need to place that image.
I was able to insert the image in the top left position with the following code. As I'll attach my file to an e-mail, without user interference, I need to position the image in a specific location, or even in a specific cell.

Can anyone help me?

Daniel Dallagnese

PROCEDURE insert_image (p_filename in varchar2) IS
args ole2.List_Type;
picture ole2.obj_type;
pictures ole2.obj_type;
pictures := ole2.invoke_obj(worksheet,'Pictures');
args := ole2.create_arglist;
ole2.add_arg(args, p_filename);
picture := ole2.invoke_obj(pictures, 'Insert', args);
Previous Topic: ole2.set_property
Next Topic: Calling Report in ASYNCHRONOUS mode in 10g/weblogic
Goto Forum:

Current Time: Mon Jul 28 19:07:42 CDT 2014

Total time taken to generate the page: 0.07166 seconds