topic Re: Export charts into excel file without installed MS-Excel on machine in QlikView

Export charts into excel file without installed MS-Excel on machine

prashantbaste — Wed, 25 Nov 2020 16:16:04 GMT

Dear All

I have a macro that exports charts from QV-Application into Excel.

In QV Application there are two tabs & each tab contains multiple charts.

Here the requirement is to export these charts into a Excel & all charts from one tab should be in one Sheet & thus there will be two Sheets in a excel file.

Since MS-Excel is not installed on machine, Macro is not able run & generate this Excel file.

Is there any way to generate Excel file with two sheets & each sheet contains multiple charts without installed MS-Excel?

Thank you in advance.

Re: export charts into excel file without installed MS-Excel on machine

bindu_apte — Tue, 07 Jun 2016 10:07:13 GMT

HI,

Do you mean that you are trying to export from QlikView Desktop installed on server.

Then QlikView will not create any file (Excel) even if you click on export to excel. Nothing will work, because no excel is installed on server.

However if you are trying to export from a browser of a client machine where you have excel installed, then the export to excel will work even though the excel is not installed on the Server from where you are hosting qlikview files.

Re: export charts into excel file without installed MS-Excel on machine

prashantbaste — Tue, 07 Jun 2016 10:15:50 GMT

Hello Bindu,

I am using Macro to Create Excel file containing QV-Exported charts (not by clicking Export to Excel)

Re: export charts into excel file without installed MS-Excel on machine

prashantbaste — Tue, 07 Jun 2016 10:20:48 GMT

One post I found Exporting object to Excel... without Excel where fkeuroglian‌ has mentioned a small code & that works fine too -

Path = "C:\TEST.xls"

set obj = ActiveDocument.GetSheetObject("CH01")

obj.ExportBiff Path

But Here only one chart is added to one Excel. My requirement is to add multiple charts on one sheet & in a way to create two sheets for charts of two Tabs of QV-Application .

can we modify above code in any way such that it can fulfill above requirement.

Thank you.

Re: export charts into excel file without installed MS-Excel on machine

trdandamudi — Tue, 07 Jun 2016 11:36:29 GMT

If you are looking to export multiple charts then I hope the below link should be helpful...

QlikTip #32: Exporting multiple QV objects to a single Excel document

Re: export charts into excel file without installed MS-Excel on machine

prashantbaste — Wed, 08 Jun 2016 04:48:39 GMT

Hello trdandamudi,

Thank you for your valuable time & reply, but as mentioned in above link - it needs to create Excel Application Object

Set objExcelApp = CreateObject("Excel.Application")

which requires MS-Excel installed on machine.

But My requirement is to generate Excel file (with multiple objects to be export) without MS-Excel installed on machine.

Is there other solution that will fulfill above requirement?

Re: Export charts into excel file without installed MS-Excel on machine

bindu_apte — Wed, 08 Jun 2016 05:01:27 GMT

Hi Prashant,

Note that if you want just export chart to excel (if you basically have to emulate context menu command `Send to Excel`) - you can do it without having Excel installed.

Use `exportBiff` method, something like:

set chart = doc.GetSheetObject("CH01")

chart.ExportBiff("AbsolutePathToFile.xls"))

I believe exportbiff exports only one chart to one excel file. So if it is crucial requirement for you, you stuck with Excel automation method. That implies you need have Excel installed.

Re: Export charts into excel file without installed MS-Excel on machine

prashantbaste — Wed, 08 Jun 2016 07:24:40 GMT

Can I export all these charts in CSV file instead XLS?

How to export multiple charts in a single CSV File?

Re: Export charts into excel file without installed MS-Excel on machine

bindu_apte — Wed, 08 Jun 2016 07:38:21 GMT

Hi,

Please find the below thread which may help you to export multiple charts to excel. Am not sure about csv file.

May be by same way you can use other macro for csv.

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

Re: Export charts into excel file without installed MS-Excel on machine

marcus_sommer — Wed, 08 Jun 2016 07:57:23 GMT

If you want to export various objects into a excel-file per macro you will need an installed excel-release - I think there is no direct way to bypass this. What speaked against an excel-installation (licence costs, security concerns, other things ...)?

Of course you could export your objects into csv or another textfile-formats - but there you have no practically way to separate those objects, you could only append one object below the anothers (which is possible - but rather difficult to split them again).

Better would be to use for each object a single csv and combine them with excel-macros within the target application. Easier then this would be to use an excel master-file which is already designed and layouted and which grabbed the data from those csv as an external data-source.

- Marcus

Re: Export charts into excel file without installed MS-Excel on machine

Wed, 08 Jun 2016 08:28:33 GMT

As a small note; its much easier to version handle and compare csv files then excel files - with could be a very time saving part if you for some reason need to do a followup on some of the data in the files.

Re: Export charts into excel file without installed MS-Excel on machine

prashantbaste — Wed, 08 Jun 2016 12:02:21 GMT

Thank you bindu.apte & marcus_sommer‌ for your valuable inputs.

Bindu, the reference you have provided was already checked, it requires CreateObject("Excel.Application") and thus MS-Excel installed, so is out-of my requirements.

Marcus, yes you are right that it needs to append each file (separation of objects if required - there we can use separate excels depending on requirements).

Finally I moved for another solution.