This discussion is archived
4 Replies Latest reply: Jan 25, 2013 12:43 PM by kps204020 RSS

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

kps204020 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points