topic Embedding qlikview objects into Excel in QlikView

Embedding qlikview objects into Excel

trdandamudi — Sun, 03 Apr 2016 01:28:20 GMT

Hi,

I am able to embed the Qlikview charts into Excel with out any issue and can use it interactively. The issue I am having is with the list boxes. When I copy the list box object just like any other object I am getting an error. Please see the attached file for the error message. I am wondering why I am not able to copy the list box objects into excel ?

Thanks

Re: Embedding qlikview objects into Excel

trdandamudi — Sun, 03 Apr 2016 11:52:55 GMT

Any idea.....?

Re: Embedding qlikview objects into Excel

maksim_senin — Mon, 04 Apr 2016 04:44:31 GMT

Hi,

It's possible to use Multi Box with added list(s).

One question - what do you need QV objects in Excel for?

Thanks.

Best regards,

Maxim

Re: Embedding qlikview objects into Excel

trdandamudi — Mon, 04 Apr 2016 11:51:04 GMT

I have no issues with multi box but not able to do the same with List box and curious to know why. Trying to see if some complex reports can be created from excel rather than generating them from qlikview.

Thanks

Re: Embedding qlikview objects into Excel

everest226 — Sat, 14 May 2016 00:01:47 GMT

found this might help

FUNCTION ExcelExport(objID)

set obj = ActiveDocument.GetSheetObject( objID )

w = obj.GetColumnCount

if obj.GetRowCount>1001 then

h=1000

else h=obj.GetRowCount

end if

Set objExcel = CreateObject("Excel.Application")

objExcel.Workbooks.Add

objExcel.Worksheets(1).select()

objExcel.Visible = True

set CellMatrix = obj.GetCells2(0,0,w,h)

column = 1

for cc=0 to w-1

objExcel.Cells(1,column).Value = CellMatrix(0)(cc).Text

objExcel.Cells(1,column).EntireRow.Font.Bold = True

column = column +1

c = 1

r =2

for RowIter=1 to h-1

for ColIter=0 to w-1

objExcel.Cells(r,c).Value = CellMatrix(RowIter)(ColIter).Text

c = c +1

r = r+1

c = 1

END FUNCTION

SUB CallExample

ExcelExport( "CH01" )

END SUB