Creating Reports in Excel Format

[Anonymous]

Hi,

Is it possible to create Qlikview reports in Excel Format without using Nprinting

Thanks,

Dhivya

[Anonymous]

What type of reports? How much detail?

[Anonymous]

In qlikview Report tab,we will create a report of the sheet in PDF format.

Instead of PDF I have to Export it to Excel without using Nprinting.

[Lech_Miszkiewicz]

What you are writing is not possible!!!

Embeded reporting tool produces reports only in PDF.

As a workaround you can export object to Excel using Macro. This however will be a lot more complicated process as it will be difficult to combine multiple objects into one excel report.

If your objective is to export maybe single table - it should be achievable.

more details here:

Qlikview to excel export macro

If you want to follow this path focus then on macros in QlikView.

On the other hand i am not big fun of using macros.

anyways - hope it helps.

[Anonymous]

Thank you

The macro below is working fine for one object but I want to export the entire sheetobjects

can you help me with the code

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

[Lech_Miszkiewicz]

well - this is exactly what i said - it is not easy to achieve this. If i knew how to do this i would give you an answer straight away.

Sorry - i am not great at macros though - so i will be no help here. Start google'ing, but i would not expect much info there...else nobody would use NPrinting, right?

good luck with this.

[Anonymous]

thank you for your help