sql to excel ...
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: sql to excel ...

  1. #1
    Join Date
    Jan 2002
    Posts
    78

    sql to excel ...

    Hi,

    We are trying to automate a process. The manual process is running some sql queries with sqlplus by spooling on. The Data generated with that is opening with excel sheet. The excel sheet is having a template with bold and colored headings.

    As of now, we have collected all those sqls and kept in a script file and that is generating data with a delimeter and with .xls extension. The same file can be directly open with the excel. The automated excel sheet is consisting of headers also.

    The problem is how to change the headers to the bold and to a specific color. Is there any way to assign bold and color characterstics to the output which is generated using sql script file?
    Share on Google+

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    closing, duplicate.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."
    Share on Google+

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width