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
Printable View
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
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).
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
try using this with the help of TOAD.
U will get such a option in toad.
http://www.quest-pipelines.com/newsletter-v5/0704_C.htm
Tom Kyte has one package(owa_sylk) that you can use
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