Discussion Board for collaboration on Qlik NPrinting.
Is it possible to create Qlikview reports in Excel Format without using Nprinting
What type of reports? How much detail?
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.
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.
The macro below is working fine for one object but I want to export the entire sheetobjects
can you help me with the code
set obj = ActiveDocument.GetSheetObject( objID )
w = obj.GetColumnCount
if obj.GetRowCount>1001 then
Set objExcel = CreateObject("Excel.Application")
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
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
ExcelExport( "CH01" )
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.
thank you for your help