How to get data in excel from QV?

[#1]

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

[sudeepkm]

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.

[Anonymous]

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

[#4]

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

AJ

[#5]

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

[anithashivalingappa]

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.

[#7]

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.

[sunilkumarqv]

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 

next

set oXL=Nothing

end sub

[#9]

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!