topic Re: Qlikview 9 Excel Export in QlikView

Qlikview 9 Excel Export

Thu, 19 Jul 2012 13:21:30 GMT

Hello Experts,

i need to run my qlikview script every night. In this qlikview script i want to export an qlikview object(table) to excel.

So when i run my script an excel export shoulld happen with data from load in the forst step.

In my script i load my data first. Then i combine my loaded data and want to export the data to excel in the last step. How can i do this? I have tried something, but without success???

I think this is possible?

I use Qlikview version 9.could anybody post some example script code?

regards

Chrisp

Re: Qlikview 9 Excel Export

jonathandienst — Thu, 19 Jul 2012 14:00:17 GMT

Chrisp

If you can live with a CSV export rather than an XLS export, then simply use in your script:

STORE ExportTable Into MyExport.csv (txt);

Where ExportTable is the table to export. Excel will open the CSV file just by double clicking on it. Exporting to XLS is more tricky.

Hope that helps

Jonathan

Re: Qlikview 9 Excel Export

Thu, 19 Jul 2012 18:19:31 GMT

hello,

you have an object in your tab and you want to export into txt,csv,ecc-

you write this macro

sub export

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportEx "\\share\nomeFile.txt", 1, true .

end sub

then Document Properties/ Trieggers/Document Event Triggers , select OnPostReload ad add macro .

So every time you reaload your document , you create a file txt,csv,ecc

God Night

Re: Qlikview 9 Excel Export

Wed, 29 Aug 2012 07:35:21 GMT

Hello,

i have write a macro to do the excel upload. it works with a button. i also add the macro at Properties/ Trieggers/Document Event Triggers , select OnPostReload

then i have enabled the reload shedule

in the qlikview script i get the data and consolidate the date in an object. The excel export macro export the data of the object to excel.

í dont want to open the qlikview document manually. Every night it should run the script to get the data and the start the excel download. All these steps need to do at night. So in the morning i want to see the updated excelsheet.

I have qlikview 11 and Qlikview Server.

what are further nessesary steps?

Could anybody help?

Re: Qlikview 9 Excel Export

Fri, 31 Aug 2012 05:59:18 GMT

I finished it. i have sheduled a task a windows task to open the qlikviw document daily. When the documents open, the script is running to get the data. After running the script the macro is excecuted, which is doing the excel download. I hope this helps somebody with related issues