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
dallagnese
Messages: 2
Registered: June 2014
Location: Brasil
Junior Member

Hello.
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?

Tks.
Daniel Dallagnese


PROCEDURE insert_image (p_filename in varchar2) IS
args ole2.List_Type;
picture ole2.obj_type;
pictures ole2.obj_type;
BEGIN
ole2.DESTROY_ARGLIST(args);
pictures := ole2.invoke_obj(worksheet,'Pictures');
args := ole2.create_arglist;
ole2.add_arg(args, p_filename);
picture := ole2.invoke_obj(pictures, 'Insert', args);
ole2.destroy_arglist(args);
END;
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