exporting data from pl/sql to excel
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).
SQL to Excel Template
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
try using this with the help of TOAD.
U will get such a option in toad.
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:
ORA_EXCEL.set_cell_value('A', 'Hello World!');
More details you can find on www.oraexcel.com
Click Here to Expand Forum to Full Width