Download Excel File from Qlikview

[prachisangewar]

Hi All,

I have a requirement wherein my users want an option to download a file on the Qlikview Dashboard.

This file is not a qlikview report.These are external files users just want to download from the Dashboard without going to another application.

Something like the "Insert Object " option in Microsoft office where we can attach a file inside the Excel or word file.

Please let me know if the requirement is not clear.

Please suggest if any solutions.

Thanks!

[sushil353 · Accepted solution]

hi,

if your excel file is stored in server and you can access that excel file using a web address then you can create a button with action>External>open url

[Anonymous]

Hi Prachi,

Take a new sheet object as BUTTON-->Action-->Action Type(External)-->Action (Run Macro)--> Macro Name (BasicExportToExcel) --> Edit Module  --> In edit module write following expression:

Sub BasicExportToExcel

DIM ExcelApplication, ExcelWorkbook

SET ExcelApplication = CREATEOBJECT("Excel.Application")

SET ExcelWorkbook = ExcelApplication.Workbooks.Add

ActiveDocument.GetSheetObject("TB01").CopyTableToClipBoard TRUE

ExcelWorkbook.Worksheets(1).Paste

ExcelApplication.DisplayAlerts = FALSE

ExcelWorkbook.SaveAs "Desktop\Test\test.xls", 56

ExcelApplication.Quit

MsgBox "Export Complete"

End Sub

Now click on Apply and OK.

Please let me know if above is not working.

Thanks,

[Anonymous]

Hi Prachi,

You can use following links for reference.

Send to Excel Button

http://buffalobi.com/qlikview/qlikview-export-to-excel-part-1/

Thanks,

[prachisangewar]

Hi Sushil,

Thank you for the suggestion!

My Excel is stored on a server,but currently i do not have any web portal as of now.I will have to develop one web page for your suggestion,will give it a try.

Any other way it can be achieved ?

Thanks !

[el_aprendiz111]

Hi,

sub Send_to_Excell
SET CHART = ActiveDocument.GetSheetObject("TB08")
SET X = Chart.GetProperties
Chart.SendToExcel
SET CHART=NOTHING
SET X = NOTHING
end sub