Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

Export reports.

How do I export a report to excel?

Thank's.

4 Replies
Highlighted
Umesh
New Contributor III

Re: Export reports.

Hi

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

      NEXT

   NEXT

   

   ' Save and quit

   objExcelSheet.SaveAs strExcelAppenFile

   objExcelApp.Application.Quit

   SET objExcelSheet = NOTHING      

   SET objExcelApp = NOTHING

END SUB

Re: Export reports.

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

javier_florian
Contributor III

Re: Export reports.

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

-Javier Florian

sudeepkm
Valued Contributor III

Re: Export reports.

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