topic Creating Reports in Excel Format in Qlik NPrinting

Creating Reports in Excel Format

Anonymous — Thu, 07 Dec 2017 10:27:08 GMT

Hi,

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

Thanks,

Dhivya

Re: Creating Reports in Excel Format

Anonymous — Thu, 07 Dec 2017 12:05:48 GMT

What type of reports? How much detail?

Re: Creating Reports in Excel Format

Anonymous — Thu, 07 Dec 2017 12:14:31 GMT

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.

Re: Creating Reports in Excel Format

Lech_Miszkiewicz — Thu, 07 Dec 2017 12:21:00 GMT

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.

Re: Creating Reports in Excel Format

Anonymous — Thu, 07 Dec 2017 12:24:27 GMT

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

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

Re: Creating Reports in Excel Format

Lech_Miszkiewicz — Thu, 07 Dec 2017 12:29:38 GMT

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.

Re: Creating Reports in Excel Format

Anonymous — Fri, 08 Dec 2017 13:26:37 GMT

thank you for your help