topic Re: Export to Excel / CSV as multiple files in QlikView

Export to Excel / CSV as multiple files

Anonymous — Mon, 08 Jun 2015 14:51:17 GMT

Friends,

I have a pivot table chart object as above. When I export to this to excel. I am able to get the export as one file. Is there any way to use a macro or something to perform a click which will split this to 3 files based on the Country and save it to a location.?

Re: Export to Excel / CSV as multiple files

robert_mika — Mon, 08 Jun 2015 15:03:01 GMT

Look here for some ideas:

www.qlikblog.at/971/qliktip-32-exporting-multiple-objects-single-excel-document/

Re: Export to Excel / CSV as multiple files

Anonymous — Mon, 08 Jun 2015 15:07:41 GMT

Thanks Rob, Let me try and will get back to you. it is a nice link.

Re: Export to Excel / CSV as multiple files

Anonymous — Tue, 09 Jun 2015 11:30:32 GMT

Hi Rob

I am getting error like below. What should I do.

My object ID is 25 so I tried below and when tried to run the macro...

Error: Type mismatch: 'copyObjectsToExcelSheet'

Code used:

Dim aryExport(25,3)

aryExport(25,0) = "objSalesPerYearAndRegion"

aryExport(25,1) = "Sales"

aryExport(25,2) = "A1"

aryExport(25,3) = "data"

Dim objExcelWorkbook 'as Excel.Workbook

Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)

Re: Export to Excel / CSV as multiple files

Anonymous — Tue, 09 Jun 2015 11:30:48 GMT

Hi Rob

I am getting error like below. What should I do.

My object ID is 25 so I tried below and when tried to run the macro...

Error: Type mismatch: 'copyObjectsToExcelSheet'

Code used:

Dim aryExport(25,3)

aryExport(25,0) = "objSalesPerYearAndRegion"

aryExport(25,1) = "Sales"

aryExport(25,2) = "A1"

aryExport(25,3) = "data"

Dim objExcelWorkbook 'as Excel.Workbook

Set objExcelWorkbook = copyObjectsToExcelSheet(ActiveDocument, aryExport)