Embedding qlikview objects into Excel

[trdandamudi]

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

[trdandamudi]

Any idea.....?

[maksim_senin]

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

[trdandamudi]

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

[everest226]

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

  next

  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

  next

  r = r+1

  c = 1

next

END FUNCTION

SUB CallExample

  ExcelExport( "CH01" )

END SUB