topic Re: Export table from load script to Excel in QlikView

Export table from load script to Excel

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

Hi all,

I would like to know if it is possible to export data from load script to an excel file as can be done with qvd.

If it is possible, can you provide some examples?

Thanks in advance.

Re: Export table from load script to Excel

trdandamudi — Wed, 04 May 2016 20:01:02 GMT

You can export to .txt file and then you can open in Excel.

store MyData into Samplefile.txt (txt);

Re: Export table from load script to Excel

santiago_respane — Thu, 05 May 2016 12:23:48 GMT

You can store in csv format in order to load it from excel (1), or you can have a table box in a hidden sheet with the data you want to export and run a macro that exports to excel after the script runs (2).

1-Store command:

STORE YourTableName into YourFile.csv (txt);

2-Macro:

sub Export

on error resume next

Set obj = ActiveDocument.GetSheetObject("ID OF THE TABLE TO EXPORT")

vPath = "Path to the excel file"

vName = "Name of the excel file"

set filesys=CreateObject("Scripting.FileSystemObject")

If Not filesys.FolderExists(vPath) Then

Set newfolder = filesys.CreateFolder(vPath)

End If

obj.ExportBiff vPath & vName

Set obj = nothing

end sub

Hope this helps.

Kind regards,

Re: Export table from load script to Excel

Anonymous — Tue, 10 May 2016 14:41:26 GMT

Thanks santiago.respaneIt worked perfectly.

Re: Export table from load script to Excel

yrstruly — Sun, 24 Nov 2019 10:38:12 GMT

Im Getting an error file not found and cant open file.Pls assist?

Re: Export table from load script to Excel

gareth_muir — Thu, 18 Mar 2021 12:15:06 GMT

My file just comes out as 'file' - i can right click and open in excel and it opens ok but i'd like to be able to export a clean xls or xlsx, any ideas on how to alter the macro to do that?