topic Re: How to export chart items data into one excel workbook as separate sheets? in QlikView

How to export chart items data into one excel workbook as separate sheets?

Thu, 26 Feb 2015 15:04:31 GMT

Hi,

I have four chart items where data export to excel workbook in to three separate sheets. In those four chart items, one is image and remaining three are table data.

Everyday there is excel file placed with template into C folder where the path is

C:CustomerData\customerInfo_26022015.xlsx

if we take tomorrow it will get as C:CustomerData\CustomerInfo_27022015.xlsx

and so on everyday.

in excel CustomerInfo_XXXXXXXX.xlsx there are three sheets A, B and C. After these three sheets the chart items should populate. up to now everyday I am manually adding chart items next to C sheet.

I want to stop this manual load. Is there any possibility with the help of macro I can do this export into CustomerInfo_XXXXXXXX.xlsx excel workbook.

Please can anyone suggest me.

Thanks.

Re: How to export chart items data into one excel workbook as separate sheets?

Gysbert_Wassenaar — Thu, 26 Feb 2015 15:40:29 GMT

See this blog post: QlikTip #32: Exporting multiple QV objects to a single Excel document

Re: How to export chart items data into one excel workbook as separate sheets?

Thu, 26 Feb 2015 15:47:24 GMT

Thanks. I have tried this. when I am using

Sample 2: More enhanced export of three objects to three different sheets

it is showing error as

Type mismatch: 'copyObjectsToExcelSheet'

Re: How to export chart items data into one excel workbook as separate sheets?

ljackson — Wed, 04 Mar 2015 10:08:01 GMT

Hi Amelia

Did you work out a solution to the mismatch error? I am having the same trouble, but my very limited knowledge of macro writing is letting me down!!!

Thanks

Leah

Re: How to export chart items data into one excel workbook as separate sheets?

Wed, 04 Mar 2015 11:32:34 GMT

no not yet

Re: How to export chart items data into one excel workbook as separate sheets?

Fri, 31 Jul 2015 15:07:37 GMT

I tried many ways. nothing seems to be not working . please can anyone suggest me how to sort out this