Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
Is it possible to create Qlikview reports in Excel Format without using Nprinting
Thanks,
Dhivya
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.
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
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