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:
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.