topic Automatic update to Excel? in QlikView

Automatic update to Excel?

Tue, 24 Feb 2015 10:44:21 GMT

Dear All,

Here in my project

I need to export from QVD to excel, But this has to happen automatically(Not by clicking export to excel option, No manual interference) and It has to done by scripting only, How?
After that the major task is, After the data got exported to excel (for example after two or three days if some data is getting updated in QV that should automatically get updated to excel also), Can the data in excel be updated ? If there is way please let me know.
I need this info on priority can some

Peter_Cammaert — Tue, 24 Feb 2015 10:56:34 GMT

In QlikView Script, there is a STORE statement that can export to csv. Excel will happily open a csv file.
An Excel file cannot be appended or updated. And in the end it wouldn't serve any purpose, because recreating a csv from the QVD is much easier and faster. You'll have to schedule a QV reload in Windows Task Scheduler if you only use QV desktop for this export. On a QlikView Server, you can schedule and manage a task.
I do not understand "...on priority can some" so I'll finish off with the QV credo: experiment and start with the simplest technique to see what works best for you.

Tue, 24 Feb 2015 11:14:21 GMT

Hi Peter ,

Thanks for your concern.

But here the customer needs to see the updated data in excel, May be twice in a day in excel only.
can this csv file be updated timely by scheduling it as you told and see the report in excel ?

i am asking again the same point to get the confidence ..