Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
NickP_DF
Creator
Creator

Export table to Excel file

Hello guys,

I need to automate by using a macro the exportation of a QV pivot table with functions, numbers, text, and Excel formulas in Excel and obtain the same result as if I'd make the "Send to Excel option";

NickP_DF_0-1631348568542.png

I found this solution 

sub ExportToExcel()
set obj = ActiveDocument.GetSheetObject("CH136")
obj.ExportEx "D:\Qlik\test.xls", 5
end sub

But it exports all data as if they are text, so that lots of data are wrong

NickP_DF_3-1631348873860.png

I've searched some documentation about the ExportEx function, but I wasn't able to find anything about 😞

Is this the right way? Am I missing something?

Thanks.

N.

 

 

 

 

1 Solution

Accepted Solutions
marcus_sommer
MVP & Luminary
MVP & Luminary

I doubt that you could get it working with the export-feature. Especially if there are various different requirements to the interpreted content and layout.

More success promises the method of copy & paste. This means creating/opening an Excel and pasting the wanted content to the intended target-areas. This allows further the possibilities to prepare the areas and/or to adjust the content afterwards if the copying doesn't fulfilled all requirements. Further it may be helpful not to transfer the origin UI objects else specialized ones from a hidden sheet to be able to use more simplified and targeted objects.

A good starting point could you find here: QlikTip #32: Exporting multiple QV objects to a single Excel document (qlikblog.at) - whereby don't use the snippets from the website else look within the download-file to see the whole code.

More easier than that could be to create an appropriate Excel file and then replacing just the source-data of it - a separate data-sheet within the Excel or maybe also using an external csv (means the Excel itself wouldn't be touched).

- Marcus

View solution in original post

2 Replies
marcus_sommer
MVP & Luminary
MVP & Luminary

I doubt that you could get it working with the export-feature. Especially if there are various different requirements to the interpreted content and layout.

More success promises the method of copy & paste. This means creating/opening an Excel and pasting the wanted content to the intended target-areas. This allows further the possibilities to prepare the areas and/or to adjust the content afterwards if the copying doesn't fulfilled all requirements. Further it may be helpful not to transfer the origin UI objects else specialized ones from a hidden sheet to be able to use more simplified and targeted objects.

A good starting point could you find here: QlikTip #32: Exporting multiple QV objects to a single Excel document (qlikblog.at) - whereby don't use the snippets from the website else look within the download-file to see the whole code.

More easier than that could be to create an appropriate Excel file and then replacing just the source-data of it - a separate data-sheet within the Excel or maybe also using an external csv (means the Excel itself wouldn't be touched).

- Marcus

NickP_DF
Creator
Creator
Author

Thank you Marcus,

I've solved thanks to your suggestion.

N.