Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
lmonincx
Creator II
Creator II

how to export picture in straight table to excel using accespoint

Hi,

I am trying to establish that the enduser can export a straight tabel to excel from the accespoint containing pictures.

In the straight table i reffer to a location on the qv server where the images are stored and inserted them in the straight table with display as an image.

Thanks for any suggestions.

Kind Regards,

Linda

3 Replies
p_verkooijen
Partner - Specialist II
Partner - Specialist II

I beleave it's only possible using macro's see Export Straight Table to Excel - Images issue

Peter_Cammaert
Partner - Champion III
Partner - Champion III

And what is not working if you export this straight table? Do you get the broken-image-icons?

QlikView will probably embed the same image URLs in the export. If they are relative to the current site, this won't work in Excel as there is no site anymore. And furthermore, as soon as the Excel file moves out of scope of your QlikView server, the references will break again.

Can you provide some more details about how your straight table refers to those images?

Peter

lmonincx
Creator II
Creator II
Author

Hi Peter,

The content (expression)  is an URL on the qv server, it's being displayed as an image, so looking at the straight tabel the cell contains an image, but as soon as it's pulled into xls the field becomes empty.

also using nprinting the same issue occurs.

Kind regards,

Linda