4 Replies Latest reply: Jan 25, 2013 2:43 PM by john204020 RSS

    Import APEX IR into Excel - BLOB-Images are not transferred

    john204020
      Hello,

      I have an Interactive Report with some alphanumerical columns and one blob column displaying the content (.jpg) as an image.
      Now I want to import the report in excel 2010 on Windows 7 64bit.
      For this I open an Excelsheet, go to Menu 'Daten', 'Aus dem Web' (sorry for this in german).
      Following the dialog I open my APEX Report and select the Report table region for import.
      All columns are imported to excel and the alphanumerical data is placed in it.
      The problem is, that the column-cells for the images are all empty (no images are transfered by this way).

      Does anyone know, how images can be transferred too by this method?

      I'm using Internet Explorer Version 9.0.12. My APEX Version is 4.1.1.00.23

      This is my Source for the Report (excerpt):
      select "LL_ERF_ID",
      "ERSTELLT_AM",
      "LETZTE_AEND_AM",
      dbms_lob.getlength("IMG1") IMG1,
      "TITEL" from mytable

      For the Report Attribute of IMG1 I use Display Type "Standard Report Column"
      The BLOB Format Mask is "IMAGE:LL_ERFASSUNG:IMG1:LL_ERF_ID::MIMETYPE_IMG1:FILENAME_IMG1:IMG1_LAST_UPDATE::inline:Download"
      The images are all type of .jpg.

      Thanks a lot for any helpful response.

      Edited by: kps204020 on 25.01.2013 14:26