6 Replies Latest reply on May 16, 2018 1:39 PM by Nivetha Ramnath

    Downloading Report with Images in xls format in Oracle APEX 4.2

    Nivetha Ramnath

      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