topic Re: Download Excel File from Qlikview in QlikView

Download Excel File from Qlikview

prachisangewar — Wed, 25 Nov 2020 16:16:04 GMT

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!

Re: Download Excel File from Qlikview

sushil353 — Mon, 19 Dec 2016 04:02:22 GMT

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

Re: Download Excel File from Qlikview

Anonymous — Mon, 19 Dec 2016 04:45:56 GMT

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,

Re: Download Excel File from Qlikview

Anonymous — Mon, 19 Dec 2016 04:54:37 GMT

Hi Prachi,

You can use following links for reference.

Send to Excel Button

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

Thanks,

Re: Download Excel File from Qlikview

prachisangewar — Mon, 19 Dec 2016 06:30:20 GMT

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 !

Re: Download Excel File from Qlikview

el_aprendiz111 — Mon, 19 Dec 2016 13:45:46 GMT

Hi,

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