Home » SQL & PL/SQL » SQL & PL/SQL » Autofit is not working while transfering data to excel from 10gdatabase
Autofit is not working while transfering data to excel from 10gdatabase [message #192290] Mon, 11 September 2006 12:40
srinivas.k2005
Messages: 338
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

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:
  


Current Time: Wed Dec 07 12:25:47 CST 2016

Total time taken to generate the page: 0.05222 seconds