Export reports.

Fri, 08 Nov 2013 18:51:30 GMT

How do I export a report to excel?

Thank's.

Re: Export reports.

Umesh — Fri, 08 Nov 2013 19:00:04 GMT

You can export the data into excel by Macro & Send to Excel

Excel Marco :

Sub Test

ExcelAppend "h:\test.xlsx", "CH01"

End Sub

Sub ExcelAppend(strExcelAppenFile, strExelAppendObjectID)

' Create an instance of Excel

SET objExcelApp = CREATEOBJECT("Excel.Application")

' Open workbook

WITH objExcelApp

.DefaultSaveFormat = xlWorkbookNormal

.DisplayAlerts = FALSE

.Workbooks.Open strExcelAppenFile

.DisplayFullScreen = FALSE

.Visible = FALSE

END WITH

' Set worksheet

SET objExcelSheet = objExcelApp.Worksheets(1)

' Set Excel used range

SET objExcelRange = objExcelSheet.Range("A65535").End(-4162)

' Last used row in column A

intExcelLastRow = objExcelRange.Row

' Set object to append from

SET objObjectFrom = ActiveDocument.GetSheetObject(strExelAppendObjectID)

' Loop all rows of the object except first header row

FOR intObjectRow = 1 To objObjectFrom.GetRowCount - 1

' Loop all columns of the object

FOR intObjectColumn = 0 To objObjectFrom.GetColumnCount - 1

' Get object data

SET objCell = objObjectFrom.GetCell(intObjectRow, intObjectColumn)

' Add that data to Excel cell

objExcelSheet.Cells(intObjectRow + intExcelLastRow, intObjectColumn + 1) = objCell.Text

' Save and quit

objExcelSheet.SaveAs strExcelAppenFile

objExcelApp.Application.Quit

SET objExcelSheet = NOTHING

SET objExcelApp = NOTHING

END SUB

Re: Export reports.

Anonymous — Fri, 08 Nov 2013 19:20:34 GMT

Igor

In a qvw dashboard you can right click most objects and then select the option to send the data to excel.

Best Regards, Bill

Re: Export reports.

javier_florian — Fri, 08 Nov 2013 21:13:22 GMT

You can work with Report Editor, is an option with QV and you can export with PDF distributor.

-Javier Florian

Re: Export reports.

sudeepkm — Sat, 09 Nov 2013 05:42:47 GMT

you can also take a look at here: http://community.qlik.com/docs/DOC-3889

topic Export reports. in QlikView

Export reports.

Re: Export reports.

Re: Export reports.

Re: Export reports.

Re: Export reports.