topic export excel automatically in QlikView

export excel automatically

Fri, 20 Nov 2020 18:02:30 GMT

Hi all,

I have a new requirement.I need qlikview table data export to excel automatically by daily basis.

can you please give some guidance.

By using micro we can export by clicking only but my client need daily basis without open the report.

Thanks

Surender

Re: export excel automatically

hariprasadqv — Thu, 02 Jul 2015 06:48:31 GMT

Hi Surender,

1.Create a qvw with a macro that can export data to excel.

2.Add Trigger to it in Document properties to activate sheet

3.Add Trigger to in sheet properties for calling Macro on sheet activation.

4.Create Batch file to run QVW

5.Schdule Batch file in windows schduler.

Thanks

Re: export excel automatically

Siva_Sankar — Thu, 02 Jul 2015 06:51:20 GMT

Reload the attached file.

Re: export excel automatically

pnn44794 — Wed, 18 Apr 2018 23:07:52 GMT

Hello Sivasankar:

I have a couple of questions if you don't mind. Does the 4 at the end of the obj1.Export line represent the number of columns to be exported? And my second question is there a way to export the data in .xlsx format? Thanks in advance.