OraFAQ Forum: SQL & PL/SQL » Autofit is not working while transfering data to excel from 10gdatabase

Home » SQL & PL/SQL » SQL & PL/SQL » Autofit is not working while transfering data to excel from 10gdatabase

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Autofit is not working while transfering data to excel from 10gdatabase [message #192290]

Mon, 11 September 2006 12:40

srinivas.k2005
Messages: 404
Registered: August 2006

Senior Member

Hi All,

I have written a procedure to export data from database.

Here is a small part.
c1:=1;
c2:=2;
args := OLE2.CREATE_ARGLIST;
OLE2.ADD_ARG(args, c1);
OLE2.ADD_ARG(args, c2);
cell := OLE2.GET_OBJ_PROPERTY(wss,'Cells', args);
OLE2.SET_PROPERTY(cell, 'value', amount);
font := ole2.get_obj_property (cell, 'Font');
ole2.set_property (font, 'Bold', TRUE);
ole2.invoke (cell, 'AutoFit');
OLE2.DESTROY_ARGLIST(args);
ole2.release_obj(cell);

But in excel sheet i am getting as ###### instead of $1,0000
even after giving ole2.invoke (cell, 'AutoFit');
please guide

Thanks,
CNU

Report message to a moderator

Previous Topic:	ORA-00911 when trying to insert user name and sysdate
Next Topic:	Not able to retrieve unicode characters on the client.

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 06 02:38:21 CST 2024