topic Re: How to get data in excel from QV? in QlikView

How to get data in excel from QV?

Wed, 05 Mar 2014 12:47:06 GMT

Hi All,

How to get data from QV in excel like QV Source in PE Edition?

Can you please give a push start how to design such thing on small level?

Thanks

Shoaib

Re: How to get data in excel from QV?

sudeepkm — Wed, 05 Mar 2014 12:54:38 GMT

Are you looking for exporting data from QlikView to XLS in that case on each of the QlikView Sheet Object you have Send to Excel option. If you are looking for loading data from Excel to QlikView then you can achieve it using Script editor and load from file option.

Kindly let me know if you are looking for something else.

Re: How to get data in excel from QV?

Anonymous — Wed, 05 Mar 2014 13:04:22 GMT

Please right click on object to export and click on send to excel option if you are looking for exporting data

if need loading data from excel see below is link:

Loading Excel Data into QlikView

Thanks

Nitha

Re: How to get data in excel from QV?

Wed, 05 Mar 2014 21:16:46 GMT

Hey Shoaib,

Do you want this export to excel feature happen automatically once the app is reloaded from a particular table in the access point?

If not then as per other suggestions you can just right click the object and select 'Send to Excel'.

Thanks

Re: How to get data in excel from QV?

Thu, 06 Mar 2014 03:23:26 GMT

I need the data refreshed in same excel file once the data is reloaded.

Re: How to get data in excel from QV?

anithashivalingappa — Thu, 06 Mar 2014 03:52:51 GMT

Hi Shoaib,

Try macros to generate excel files. Before closing the QVW file while data reload macros generates the excel and save it in provided path.

Re: How to get data in excel from QV?

Thu, 06 Mar 2014 05:12:42 GMT

Hi Shoaib

You can use post relaod send to excel macro.

Sub sendtoexcel

ActiveDocument.GetSheetobject("chartID").ExportBiff "Save File Path"

End Sub

It will automatically export the data into excel.

Re: How to get data in excel from QV?

sunilkumarqv — Thu, 06 Mar 2014 06:06:14 GMT

By the help of macros, we can export data from multiple objects (table charts, table boxes) into excel.

All we need to do is to pass the Object IDs in the highlighted line of the macro code below and run the macro by a Button.

//Pls. note that Current Local Security level (in the edit module screen) should be set to Allow Sytem Access level.

//Macro code:

sub launchXL

set oXL=CreateObject("Excel.Application")

oXL.visible=True

oXL.Workbooks.Add

aSheetObj=Array("TB01","CH01")

for i=0 to UBound(aSheetObj)

oXL.Sheets.Add

Set oSH = oXL.ActiveSheet

oSH.Range("A1").Select

Set obj = ActiveDocument.GetSheetObject(aSheetObj(i))

obj.CopyTableToClipboard True

oSH.Paste

sCaption=obj.GetCaption.Name.v

set obj=Nothing

oSH.Rows("1:1").Select

oXL.Selection.Font.Bold = True

oSH.Cells.Select

oXL.Selection.Columns.AutoFit

oSH.Range("A1").Select

oSH.Name=left(sCaption,30)

set oSH=Nothing

set oXL=Nothing

end sub

Re: How to get data in excel from QV?

Thu, 06 Mar 2014 06:55:10 GMT

Hi Shoaib,

If you need your data refreshed in excel after it is reloaded then you can use your macro/trigger for export to excel on Document Event trigger "OnPostReload".

You can also refer to this:

http://community.qlik.com/message/471810#471810

Hope this helps!