Export to Excel by Button

[#1]

jagan‌ vinay_bangari‌ ecolomer‌

Hi Experts,

I'm not familiar with macros at all…! Unfortunately, not even the basics..

I need a button that will export a table to excel. Please find the attached qvw file below.

Thank you in advance.

[#2]

Hi Gennaro,

Sorry, One more question..  Is there anyway that we can Export to PDF by creating the Macro..???

Thanks,

Raji

[#3]

Hello Raji,
there is no way to export directly to PDF, but you can use QlikView reports.

That is, it creates one or more reports and then with a macro molds in PDF via the API PDFCreator you have to install on the machine where you use the qvw.

I hope I was clear.

[gautik92]

Have a look at this

[#5]

g.voto76‌

Hi Gennaro,

Thanks for the Response. I have couple of questions.

• Do i have to install API PDFCreator on my Local Machine..??
• If i move my Application to the Production Machine what will happen..?? Will it work..??
• The Macro which we created before for Export to Excel will that also work in Prod Machine..??

Thanks for your help..

Raji

[#6]

Hi Gennaro,

I have one more issue with this Macro.. I'm trying to display 3 objects at a time in Excel sheets. But some how its not working. Can you please help me on this too..?? Please find the attached qvw file with name "2ObjectsforMacro" (In this File i have taken a container Chart but its not exporting to excel because the container has 2 objects)

Thank you for your patience.

[#7]

Hi Raji,

You can not export a container object, but only the objects that are contained in it.
Excuse but today I can mdificarti your qvw to other work commitments.
If you can wait and not solve in the meantime I can control it between 7/8 hours or tomorrow morning (Italian time).

[#8]

Sure i'll wait for your response.. Thank You..

[#9]

Hi Raji,

sorry for the delay.
Attached you can find your qvw modified to print the two objects in the container.
I added the variables and created a new function in the macro.
Watch the action on one of the buttons and you'll understand.

Regards

Gennaro

[#10]

Hi Gennaro,

Thanks for the Response. I have couple of questions.
•Do i have to install API PDFCreator on my Local Machine..??
•If i move my Application to the Production Machine what will happen..?? Will it work..??
•The Macro which we created before for Export to Excel will that also work in Prod Machine..??

Thanks for your help..

Raji

[#11]

Hi Raji,

PDFCreator is used to create PDF files (simulates a virtual printer that creates a PDF file that you send in press), if you need to produce PDF you have to install it on your local machine and on the production server.
On the production server to ensure that the MACRO functions you need to enable the execution of the macro in the QMC.

In the System tab select the QlikView Server QVS @ xxxxx and select the Security tab and active flag "Allow macro execution on server"

Regards

Gennaro