topic Ajax application won't export to excel in QlikView

Ajax application won't export to excel

Mon, 26 Jan 2026 18:19:17 GMT

We have an ajax page that has four tables on it. When I try to export any of the table to excel, the popup window pops up like it should, but instead of prompting for "would you like to open or save the file", the page comes up with the "unable to view the webpage" error. the URL of the popup reads "http://qlikview/qvprint/*a bunch of letters".xls. I've also tried to export to a .csv and it fails as well. Does anyone know why this is occuring. It works on some machines but not on others and I'm not sure what setting would be doing this (IE setting, QV setting, security, firewall, etc). thanks.

Ajax application won't export to excel

Wed, 07 Oct 2009 20:54:48 GMT

I'm having a very similar issue. Our issue is with the Internet Explorer browser exporting reports as excel in AJAX. It works fine with the IE Plug-in in Internet Explorer, with Firefox in AJAX, and Crome in AJAX, but not with Internet Explorer in AJAX. We aren't getting the error that you are, which might have something to do with you have the "Web Folders" tab set up on your QVS Console. When we were getting an error, when we tried downloading the file, we changed our URL to https in the "Web Folders" URL box on the QVS Management console so it ran over the secure port. That fixed the error message, but didn't fix the fact that the file wasn't downloading...

I have a ticket into the support team at QlikTech. They have forwarded my request on to the second level of support. I'll be sure to provide an update if they get a fix for me.

rob

Ajax application won't export to excel

Wed, 07 Oct 2009 21:01:30 GMT

Thanks alot. I've tried everything I can think of. We tried changing all the IE security settings, the versions of excel, upgrading IE and nothing works. Hopefully they can figure something out.

Ajax application won't export to excel

philip_doyne — Fri, 06 Nov 2009 00:01:19 GMT

Hi All,

Experiencing exactly the same issue with QVS 9.0 SR2 (released on 30Oct). Symptoms exactly as described above but the same things happens for both Print Export and Send to Excel. In my case I only care about the AJAX client - no info about others. I have 9.00 SR1 installed locally on my PC and it works fine on that so it must be something to do with some security setting. I have Windows Server 2008 on the server. It does not seem to be browser - in IE6 I get the standard windows "The page cannot be displayed" in IE7 I get a blank page. I would expect the Send to Excel to bring up the Open/Save dialog and the Print to put the output in HTML in the web page. It seems odd that it s trying to display the XLS in a web page. Any QlikTechers on line to comment. Also have a call in to support.

Philip

Ajax application won't export to excel

Fri, 06 Nov 2009 01:52:11 GMT

Same here. I also have a ticket open. Please everyone keep us posted. I get more answers from teh Forum them Support.

Good Luck,

Moe

p.s. I will keep you all posted.

Ajax application won't export to excel

Fri, 06 Nov 2009 02:14:43 GMT

I actually got mine working here. I don't know if all of your systems are the same way, but here's what I had to do:

Ours is a sharepoint portal that links back to QV. I set up a virtual directory in IIS on our sharepoint server that links back to the printing folder through the server management console. I believe ours is something like "c:\inetpub\wwwroot\Qvprint" on our QV server. I'm assuming if you're not running through a portal you can set up a virtual directory through IIS on the actual QV server that points back to the printing folder just the same. I also changed the URL in the web folder section to be a full URL. I believe the default is just "http://QLIKVIEW/QvPrint. I changed that to http://qlikview.(whateveryoursis).com/QvPrint path. You should be able to see the full path after the domain in the ASP net section of your IIS and it's listed in virutal path. Now I also had to change the security on the QV print directory in IIS to allow anonymous access to let people go through. I had the anonymous access set to our sharepoint admin username/password and that corrected the issue. If you're not going through another box I don't know if you need anonymous or not. If your webpage authenticates back to the server as a specific username you might have to set that username as the anonymous access. Hope this helps everyone else...feel free to post if you have any questions. i'm running 8.5 here so I don't know how this translates to other versions.

Ajax application won't export to excel

philip_doyne — Fri, 06 Nov 2009 02:23:06 GMT

Thanks for that - a partial solution for me - I did have Basic Authentication set on the QVPrint virtual folder and after changing it to Anonymous only the Print and Export functions worked but not the Send to Excel Open/Save.

Ajax application won't export to excel

Mon, 23 Nov 2009 18:41:19 GMT

Hi,

Any solution related to IE "send to Excel" issue? BR, Abu

Ajax application won't export to excel

Mon, 23 Nov 2009 21:19:46 GMT

My previous post solved the issue from the ajax client here. We've run into a few other minor things on clients machines that could potentially be a client issue instead of a qlikivew issue from an ajax page:

1. Popup blocker cancelling the page since it pops up in a new window

2. Firewall stops the excel page from opening correctly. This is caused by the way ours is set up. The sharepoint page gets through most firewalls just fine and we have in Iframe that goes to the QV page. When ti send it to excel it tries to open a new domain/SSL cert and some firewalls block that from happening.

3. Every once and a while there's a security setting in IE that breaks it. I just reset everything to default in the IE security/advanced settings.

That's about all I know at this point - since we got it up and running on our side I haven't really looked at it too much though. Thanks

Ajax application won't export to excel

Tue, 24 Nov 2009 00:53:51 GMT

I think Your issue may be down to the 2008 server, I have a qvw with Some FileOpen functionality on a macro and it wont run on the server as it cant find a suitable Fileopen Dialog control on the server OS.

Mabe this is a similar issue somehow. Have you got a test box running an older Server OS ?

ColinR

Ajax application won't export to excel

Tue, 24 Nov 2009 01:12:06 GMT

Thanks for your post - but I still am having trouble with IE (both 7 and 😎 in AJAX mode and opening an excel export.

I have minimized security on both the server and client (even less than the default setting you mentioned above) and what happens when I select the export to excel icon, I get a short hour glass and a pop-up window flashes (too fast to see the full URL) - but it appears to have the right format and the file gets created on the server (and pasting that QV path and file name into the IE url address line does bring up the excel file). So it kind of acts like a pop-up blocker - but they are all shut off on my box.

Any more suggestions?

Thanks

Ajax application won't export to excel

Tue, 24 Nov 2009 16:27:17 GMT

Hello,

I have got a solution from QV. It's clearly related with browser and working for me.

Need to do:

In IE (I am using version 8), go to tools->internet options->Internet->custom level->in downloads settings, select Enable.

In Safari, Edit-> uncheck Block Pop-up Windows.

Cheers.

Ajax application won't export to excel

Thu, 28 Jan 2010 17:44:31 GMT

My symptoms were a bit different - the popup page only showed up for a fraction of a second in IE7/IE8, but worked in Firefox.

I traced the problem down to the prompt that asks if you are sure you wish to open or save the file. Clicking the checkbox fixed the problem for fugure Export-to-Excel operations.

Setting a binary value of "0000" for this Windows registry key works:

HKEY_CURRENT_USER\Software\Microsoft\Windows\Shell\AttachmentExecute\{0002DF01-0000-0000-C000-000000000046}\Excel.Sheet.8

I created a file named "ExportToExcelFix.reg" and made it available to my web clients. Running this file fixes the Export-to-Excel problem. Note that I also had to update my IIS Mime Types so that ".reg" files are sent as "application/octet-stream" when distributing this .reg file over the web.

Matt Clark

Ajax application won't export to excel

Wed, 24 Mar 2010 15:48:44 GMT

Hi,

did you found a solution for this problem? We've encounterd the same behavior - Excel export works in all browsers except in IE.

When we click on the excel icon or right mouse click "send to excel" the download dialog does not appear.

Thanks in advance!

Regards

Ajax application won't export to excel

Fri, 30 Apr 2010 14:40:04 GMT

This is a known issue and will be fixed in SR4.

/anders

Ajax application won't export to excel

Mon, 17 May 2010 12:33:16 GMT

I'm having problems with this. However, the problem I'm having seems to be because we are using a non-standard port (8080) for the web server. The port setting doesn't seem to be getting correctly transferred to the url for the download. Anybody know where this is set in the server? (I found it in the registry, but would rather not hack around in there!)

Bob

Ajax application won't export to excel

Tue, 24 Aug 2010 14:47:19 GMT

I was having the same problem with my QvPrint Export to Excel (QV9 x64 SR4). The solution that worked for me was to explicitly state the web URL in the QMC at QlikView Server Settings -> Print -> URL. I replaced the server name there with the specific URL that should be used and it worked like a charm.

Ajax application won't export to excel

canariam — Tue, 07 Sep 2010 13:26:41 GMT

hi all,

i handled this problem easily.

1) open qlikview managemanet console

2) qlikview server settings

3) print

u will see this directory in the second row: 'C:\Documents and Settings\All Users\Application Data\QlikTech\Qvs'

go to that directory and creat a new folder named as 'QvPrint'

then

copy & paste your new directory to folder part.

like this 'C:\Documents and Settings\All Users\Application Data\QlikTech\Qvs\QvPrint\'

that s it!!!

Ajax application won't export to excel

Tue, 07 Sep 2010 23:05:17 GMT

Thanks - I have been travelling, so no chance to try it out yet.