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
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!');