DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: exporting data from pl/sql to excel

  1. #1
    Join Date
    Sep 2001
    Location
    UK
    Posts
    45

    exporting data from pl/sql to excel

    Hi,

    is there any way i can directly export data from a PL/SQL block to an Excel file

    I tried using utl_file utility but it didn't work

  2. #2
    Join Date
    Mar 2001
    Location
    Reading, U.K
    Posts
    598
    You could export the data to a text file (using UTL_FILE) and then import the text file manually in Excel (either fixed length or demilited option).
    Cheers!
    OraKid.

  3. #3
    Join Date
    Dec 2007
    Posts
    2

    SQL to Excel Template

    Hi there,

    I would like to know the procedure of automatically filling out a template with the information that is in SQL.
    I have a new template in Excel and I want to map the cells to the values from SQL. How would that be accomplished?
    I would appreciate the information

    Thanks
    Sharjeel

  4. #4
    Join Date
    Dec 2007
    Location
    MUMBAI, India
    Posts
    2
    try using this with the help of TOAD.
    U will get such a option in toad.

  5. #5
    Join Date
    Jul 2002
    Location
    Slovenia
    Posts
    42

    owa_sylk

    http://www.quest-pipelines.com/newsletter-v5/0704_C.htm

    Tom Kyte has one package(owa_sylk) that you can use
    Andrej

  6. #6
    Join Date
    Dec 2011
    Posts
    2
    Hello,

    there is great Oracle PL/SQL package ORA_EXCEL which can produce Excel xlsx files from an Oracle database using only PL/SQL.

    It is easy to use this package, one simple example code that generates Excel file:
    BEGIN
    ORA_EXCEL.new_document;
    ORA_EXCEL.add_sheet('My Sheet');
    ORA_EXCEL.add_row;
    ORA_EXCEL.set_cell_value('A', 'Hello World!');
    ORA_EXCEL.save_to_file('EXPORT_DIR', 'example.xlsx');
    END;

    More details you can find on www.oraexcel.com

    Greetings

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