Hi sir\Friends,
I am using the pl\sql cartridges for creating the Applications and then placing in Oracle Application
which i have created the User(SEENU) which i have created the User(SEENU) having forms and reports .............
.............
But i want the Columns be bold in the EXCEL Sheet when it was opened.. or any other option....
PROCEDURE Excel
( p_customer_id IN NUMBER ,
p_customer_name IN VARCHAR2 ,
p_customer_Address IN VARCHAR2 DEFAULT NULL,
p_Type IN VARCHAR2 DEFAULT 'EXCEL'
)
IS
CURSOR c_cust
IS
SELECT customer_id, customer_name, customer_Address
FROM CustomerInfo
ORDER BY customer_name;
v_cust v_cust%rowtype;
i NUMBER := 0;
fldSep CHAR(1);
BEGIN
IF ( p_Type = 'EXCEL' ) THEN
fldSep := CHR(9);
owa_util.mime_header( 'application/vnd.ms-excel', TRUE );
htp.print( 'Customer No'
|| fldSep || 'Customer Name'
|| fldSep || 'Customer Address'
);
FOR v_cust IN c_cust
LOOP
htp.print( v_cust.Customer_No
|| fldSep || v_cust.Customer_Name
|| fldSep || v_cust.Customer_Address
);
END LOOP;
END IF;
END;
---------*** The OUTPUT is ***----------
Customer No Customer Name Customer Address
1001 John Laaat pet
1002 Abhi Nungam pet
1003 Seenu Thiru pet
Regards
Seenu