Home » Developer & Programmer » Forms » How to: Export data to excel with unicode font (Vietnamese) in oracle form by WebUtil (Oracle form 10g, Win7 pro)
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Feb 03 02:15:27 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.