topic Re: Is it possible to export straight table(contain info images as column) to excel as a data set(2016)? in QlikView

Is it possible to export straight table(contain info images as column) to excel as a data set(2016)?

Wed, 25 Nov 2020 16:16:04 GMT

Is it possible to export straight table(contain info images as column) to excel as a data set(2016)? I have searched for many posts and also Google? Marco or any other methods are welcome! Thanks

Re: Is it possible to export straight table(contain info images as column) to excel as a data set(2016)?

bindu_apte — Mon, 27 Jun 2016 06:54:13 GMT

Hi,

I dont think you can export to excel which is having images.

Re: Is it possible to export straight table(contain info images as column) to excel as a data set(2016)?

avinashelite — Mon, 27 Jun 2016 06:58:12 GMT

I think you need to make use of macro for this ...check this thread will help you

Export Straight Table to Excel - Images issue

Re: Is it possible to export straight table(contain info images as column) to excel as a data set(2016)?

Anil_Babu_Samineni — Mon, 27 Jun 2016 06:59:21 GMT

This macro will do this, and will not append the objects title.

Just call the function with the full file and path to the excel file and the Object ID.

Sub Test
ExcelAppend "h:\test.xlsx", "CH01"
End Sub
Sub ExcelAppend(strExcelAppenFile, strExelAppendObjectID)
' Create an instance of Excel
SET objExcelApp = CREATEOBJECT("Excel.Application")
' Open workbook
WITH objExcelApp
.DefaultSaveFormat = xlWorkbookNormal
.DisplayAlerts = FALSE
.Workbooks.Open strExcelAppenFile
.DisplayFullScreen = FALSE
.Visible = FALSE
END WITH
' Set worksheet
SET objExcelSheet = objExcelApp.Worksheets(1)
' Set Excel used range
SET objExcelRange = objExcelSheet.Range("A65535").End(-4162)
' Last used row in column A
intExcelLastRow = objExcelRange.Row
' Set object to append from
SET objObjectFrom = ActiveDocument.GetSheetObject(strExelAppendObjectID)
' Loop all rows of the object except first header row
FOR intObjectRow = 1 To objObjectFrom.GetRowCount - 1
' Loop all columns of the object
FOR intObjectColumn = 0 To objObjectFrom.GetColumnCount - 1
' Get object data
SET objCell = objObjectFrom.GetCell(intObjectRow, intObjectColumn)
' Add that data to Excel cell
objExcelSheet.Cells(intObjectRow + intExcelLastRow, intObjectColumn + 1) = objCell.Text
NEXT
NEXT
' Save and quit
objExcelSheet.SaveAs strExcelAppenFile
objExcelApp.Application.Quit
SET objExcelSheet = NOTHING
SET objExcelApp = NOTHING
END SUB

Re: Is it possible to export straight table(contain info images as column) to excel as a data set(2016)?

Mon, 27 Jun 2016 07:45:52 GMT

Thanks sir, I have tried on this but it only turned a single object into img or data(Not the one I want).

Re: Is it possible to export straight table(contain info images as column) to excel as a data set(2016)?

Mon, 27 Jun 2016 07:46:42 GMT

Thanks sir, but the last column(Image) are missing after it is exported! ;(

Re: Is it possible to export straight table(contain info images as column) to excel as a data set(2016)?

Mon, 27 Jun 2016 07:59:25 GMT

Sir, for more, it is not an URL, the images are loaded using BUNDLE INFO LOAD and displayed by info()