Hi,
I have a report with the columns Empno, Ename, Photo.
My photo column is BLOB column.
I have custom Download button for download process of the report.
Step 1:
I have created a new blank page in the application using Customized template, where I have removed all the navigation menus, APEX page Toolbar, and others.
Step 2:
I have created PLSQL region with no template:
BEGIN
HTP.p
('<table border=1 white-space=nowrap><tr style="background-color:silver;">
<th>Empno</th><th>Name</th>
<th>Photo</th></tr>'
);
FOR i IN (SELECT empno, ename, photo
FROM emp)
LOOP
HTP.p ( '<tr height=80><th align=right>'
|| i.empno
|| '</th><th>'
|| i.ename
|| '</th><th><img src="'
|| i.photo
|| '">
</th></tr>'
);
END LOOP;
END;
Step 3:
Created Before Header process to set HTTP Headers.
BEGIN
OWA_UTIL.mime_header ('application/vnd.ms-excel', FALSE);
HTP.prn
('Content-Disposition: attachment; filename="Employee_Details.xls"
' );
OWA_UTIL.http_header_close;
END;
Step 4:
Redirected the Download button to the new page created.
Am getting all the other columns correctly in my excel file but not the image column.
How should I call the image column in excel file in downloading from Oracle APEX 4.2(Should support any version of APEX)?
Thank you.
Regards,
Nivetha Ramnath