topic Re: Export to Excel not working. in QlikView

Export to Excel not working.

Anonymous — Tue, 18 Nov 2014 11:07:29 GMT

Hi ,

we are facing an issue that export to excel is not working on Access point and working fine on qlikview designer(server).

what could be the possible reasons, we have added a links on trusted sites and IE v11 is installed on server.

Thanks

Manish

Re: Export to Excel not working.

vikasmahajan — Tue, 18 Nov 2014 11:14:48 GMT

Please try this thread Ashfauq given solution

Export to excel giving problem while export from Access Point

Vikas

Re: Export to Excel not working.

Anonymous — Tue, 18 Nov 2014 11:30:31 GMT

I cant see Web tab on left side.

To enable that do we need to setup any other particular settings.

Thanks

Manish

Re: Export to Excel not working.

Anonymous — Tue, 18 Nov 2014 11:34:49 GMT

typo Right* side

Re: Re: Export to Excel not working.

ashfaq_haseeb — Tue, 18 Nov 2014 11:39:29 GMT

Hi,

have a look at attached image.

Regards

ASHFAQ

Re: Export to Excel not working.

Anonymous — Tue, 18 Nov 2014 11:47:02 GMT

seems to be same as you have mentioned.

have a look:

what next?

Re: Export to Excel not working.

ashfaq_haseeb — Tue, 18 Nov 2014 11:53:06 GMT

Hi,

Do you have .csv too can you confirm?

Regards

ASHFAQ

Re: Export to Excel not working.

Anonymous — Tue, 18 Nov 2014 11:57:17 GMT

yes.

Re: Export to Excel not working.

ashfaq_haseeb — Tue, 18 Nov 2014 11:59:35 GMT

What exact error do you get.

Did you try from other browser?

Did you try from some other machine then server?

Can you share snapshots of error you get?

Regards

ASHFAQ

Re: Export to Excel not working.

Anonymous — Tue, 18 Nov 2014 12:07:46 GMT

on server only IE v11 is installed i tried on that only there is nothing happening when i click on button.

below is macro script:

sub Export_reported

set XLApp = CreateObject("Excel.Application")

XLApp.Visible = true 'you can make it false, if you want to make it in the background

set XLDoc = XLApp.Workbooks.Add

XLDoc.Sheets(1).name = "Export"

set XLSheet = XLDoc.Worksheets(1)

set MyTable = ActiveDocument.GetSheetObject("CH171") 'Change TB01 to the object you want to export to Excel (Object Properties > General tab > far right)

set XLSheet = XLDoc.Worksheets(1) 'Select sheet where data should be pasted

Mytable.CopyTableToClipboard true 'Copy data to Clipboard

XLSheet.Paste XLSheet.Range("A1") 'Paste data starting at A1

End Sub

same macro is working on same server QV designer mode.

Thanks

Manish Madan

Re: Export to Excel not working.

ashfaq_haseeb — Tue, 18 Nov 2014 12:23:06 GMT

Hi,

This is known thing.

Not all macros work on server.

Instead I suggest you to use IE pluggin and check if that worked.

Let me know if that worked.

Regards

ASHFAQ

Re: Export to Excel not working.

Anonymous — Tue, 18 Nov 2014 12:32:14 GMT

I think your document is not opening in IE plugins by default .. Just click on 'Details' below your document you will see two options select '

Re: Export to Excel not working.

Anonymous — Tue, 18 Nov 2014 13:04:25 GMT

Hi Ashfaq, Balkumarchandel

As of now only full browser version i can see.

can you please guide with the link where I should download the IE plugin or it is general.

Thanks

Manish

Re: Export to Excel not working.

Anonymous — Tue, 18 Nov 2014 13:32:52 GMT

Hi ,

close internet explorer and then follow previous steps.

Re: Export to Excel not working.

Anonymous — Tue, 18 Nov 2014 13:42:24 GMT

Thanks Ashfaq and Balkumarchandel.

It is working on Access point(local host) inside the server but still outside the server(using IP address) not working neither i am able to see download plug in.

any suggestion?

Re: Export to Excel not working.

Anonymous — Wed, 19 Nov 2014 15:42:24 GMT

In the QVS config part of QMC, try specifying a named folder for the "Alternate Temporary Files Folder Path".

When users aren't able to export, I've had good luck seeing if a file makes it at least that far before appearing client-side.