Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Export reports.

How do I export a report to excel?

Thank's.

4 Replies
Highlighted
Umesh
Not applicable

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

bill_markham
Not applicable

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
Not applicable

Re: Export reports.

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

-Javier Florian

sudeepkm
Not applicable

Re: Export reports.

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