OraFAQ Forum: Forms » How to: Export data to excel with unicode font (Vietnamese) in oracle form by WebUtil

Home » Developer & Programmer » Forms » How to: Export data to excel with unicode font (Vietnamese) in oracle form by WebUtil (Oracle form 10g, Win7 pro)

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

How to: Export data to excel with unicode font (Vietnamese) in oracle form by WebUtil [message #554361]

Sun, 13 May 2012 22:19

tieudieuphong
Messages: 10
Registered: April 2012
Location: Viet Nam

Junior Member

How to use webutil to export data from oracle database to excel file with unicode font?

I have procedure :

PROCEDURE SET_VALUE_CELL
(
row_excel number, -- row index
col_excel number, -- column index
strvalue nvarchar2 -- string value to input excel file with unicode font (Vietnamese)
)
IS

BEGIN
--Thiet lap vi tri cell bat dau
args := client_OLE2.CREATE_ARGLIST;
client_ole2.ADD_ARG(args, row_excel);
client_ole2.ADD_ARG(args, col_excel);

--Lay vi tri cell trong worksheet
cell := client_ole2.GET_OBJ_PROPERTY(worksheet, 'Cells', args);
client_ole2.DESTROY_ARGLIST(args);

--Lay gia tri cua cell
args := client_OLE2.CREATE_ARGLIST;
client_ole2.SET_PROPERTY(cell, 'Value', strvalue, args);
client_ole2.DESTROY_ARGLIST(args);

END;

Help me!!!

Report message to a moderator

Previous Topic:	How to: Read a range of excel by webutil?
Next Topic:	Scrollbar & disabled button issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jul 05 21:36:19 CDT 2024