Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Not applicable

export excel automatically

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

Tags (2)
1 Solution

Accepted Solutions
Siva_Sankar
Honored Contributor

Re: export excel automatically

Reload the attached file.

3 Replies
Highlighted
hariprasadqv
Contributor III

Re: export excel automatically

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

Siva_Sankar
Honored Contributor

Re: export excel automatically

Reload the attached file.

Partner
Partner

Re: export excel automatically

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.