Home » SQL & PL/SQL » SQL & PL/SQL » Can we get the Columns be bold in the EXCEL Sheet when it was opened
Can we get the Columns be bold in the EXCEL Sheet when it was opened [message #297159] Wed, 30 January 2008 06:50 Go to next message
seenujanu
Messages: 53
Registered: August 2006
Location: chennai
Member
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



Re: Can we get the Columns be bold in the EXCEL Sheet when it was opened [message #297161 is a reply to message #297159] Wed, 30 January 2008 06:54 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is an Excel question not an Oracle one.
How is bold coded in Excel?

Regards
Michel
Previous Topic: Closing file using HTP
Next Topic: How to free exclusive row lock after deadlock???
Goto Forum:
  


Current Time: Fri Dec 09 19:28:04 CST 2016

Total time taken to generate the page: 0.08055 seconds