exporting data from pl/sql to excel

[dinesh_hm]

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

[balajiyes]

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).

[Silence]

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

[SF ABBAS]

try using this with the help of TOAD.
U will get such a option in toad.

[andrejm]

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

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

[bestija]

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