Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

dvzjsnu123
Contributor

Creating Reports in Excel Format

Hi,

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

Thanks,

Dhivya

6 Replies
michaelblackbur
New Contributor III

Re: Creating Reports in Excel Format

What type of reports? How much detail?

dvzjsnu123
Contributor

Re: Creating Reports in Excel Format

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_miszkiewic
Honored Contributor III

Re: Creating Reports in Excel Format

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.

dvzjsnu123
Contributor

Re: Creating Reports in Excel Format

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_miszkiewic
Honored Contributor III

Re: Creating Reports in Excel Format

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.

dvzjsnu123
Contributor

Re: Creating Reports in Excel Format

thank you for your help

Community Browser