|
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|