Dim url_column As Range
Dim image_column As Range
Set url_column = Worksheets(1).UsedRange.Columns("A")
Set image_column = Worksheets(1).UsedRange.Columns("B")
Dim i As Long
For i = 1 To url_column.Cells.Count
With image_column.Worksheet.Pictures.Insert(url_column.Cells(i).Value)
.Left = image_column.Cells(i).Left
.Top = image_column.Cells(i).Top
image_column.Cells(i).EntireRow.RowHeight = .Height
End With
Next
Note: that as this needs to be developed in Excel, this is outside of the scope of Qlik Support and please use it own risk.
Knowledge
QlikView: Exporting images from a table to Excel
Article Number: 000050722 | Last Modified: 2019/04/12Description
Unfortunately, there is not a build in functionality to export images from a QlikView table to Excel.
Resolution
Possible workaround outside of QlikView (this should be configured in Excel):
- Export images as a URL (FQDN is required) and try to run the following VBA script in Excel to render the URL as an image:
Get Answers
Find Answers
Qlik Community
Collaborate with over 60,000 Qlik technologists and members around the world to get answers to your questions, and maximize success.
Join Us
Get Support
Have a Question?
Search Qlik's Support Knowledge database or request assisted support for highly complex issues.
Submit a case
Talk with a Representative
Critical Issues
Experiencing a serious issue, please contact us by phone. For Data Integration related issues please refer to your onboarding documentation for current phone number.
Call Us