I ‘ve been thinking how difficult to export all layout report to excel file. It may caused by owa_sylk package just like I’ve used. It seems the best tool that I ever used, but I think it has limitation if I should parse 2 querys or more and report must be composed in formated xls file.
I’ve got an idea to put htp.init and owa_util.mime_header(‘application/vnd.ms-excel’) as header, hope that it would create .xls file as I expected :
create or replace procedure xls_view is
cursor c_data is
select * from mytable where name=me;
htp.p(‘<table border=”1″><tr>NICK NAME<td></td><td>FULL NAME</td></tr>’);
for j in c_data
when others then
Yeaa..I made it, it’s work fine all data has exported. Next step, I’ve tried to put 3 table using 3 different cursors so far there’s no problem to system.
But, this methods has some limitations:
Some case, if web page composed by layers file would not created as we expected. This can be understood cause layer placed using relative-positions.
So, this method is very helpfull to export html report with data composed in tables only not using div layer. Next questions is what should we do to give a name to that file?
Filename can be define by placed this scipt before owa_util.http_header_close;
If You do this, You should set owa_util.mime_header into false condition too, if You don’t filename would be created as like as Your procedure name.