topic Re: Create an Excel document while using AJAX in QlikView

Create an Excel document while using AJAX

Oleg_Troyansky — Mon, 26 Jan 2026 16:26:21 GMT

Hi everybody,

a question for people that know a thing or two about extensions...

It looks like it's impossible to generate an Excel file via macro while running AJAX client... Do you think it's possible to develop an Extension (either an Extension Object or a Document Extension) that could generate an Excel file based on a given set of rows and columns? Would it be something difficult or easy to accomplish?

thanks in advance,

Oleg Troyansky

Re: Create an Excel document while using AJAX

Alexander_Thor — Tue, 26 Feb 2013 16:22:45 GMT

Would a csv file be acceptable? That is pretty easy to generate client side, if you want to generate a excelfile most likely you would want to create a server side call which I guess is kind of redudant since you pass the data to the client, then back to the server and then back as a excelfile but hey some users dig excel

Edit: I have an old example that generates a csv file, let me port that over to QV11 and fine-tune it and I'll post it later tonight.

Re: Create an Excel document while using AJAX

rbecher — Tue, 26 Feb 2013 16:30:40 GMT

Btw. I've build an extension which downloads the data as CSV using data URI. Unfortunately this is only working in Chrome and Firefox.

- Ralf

Re: Create an Excel document while using AJAX

rbecher — Tue, 26 Feb 2013 16:31:51 GMT

Hi Alex,

how is your solution working?

- Ralf

Re: Create an Excel document while using AJAX

Alexander_Thor — Tue, 26 Feb 2013 16:54:25 GMT

Well I'm using the blob object that's part of the File API so any modern browser should support it. So in other words no IE8/9.

http://caniuse.com/bloburls

Kind Regards

Alexander Karlsson

26 feb 2013 kl. 17:31 skrev "Ralf Becher" <qcwebmaster@qlik.com<mailto:qcwebmaster@qlik.com>>:

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Create an Excel document while using AJAX

created by Ralf Becher<http://community.qlik.com/people/rbecher> in Integration and Extensions - View the full discussion<http://community.qlik.com/message/315761#315761>

Re: Create an Excel document while using AJAX

Oleg_Troyansky — Tue, 26 Feb 2013 18:31:15 GMT

Hi Alex and Ralf,

thank you for your responses. Here is my situation with this request:

- the client is using IE 8.0 as a corporate policy, and I'm afraid we can't change that...

- the need was to store an Excel or a CSV file on the server for later processing, without opening the file to the user. They would actually prefer that the action of storing is performed silently, with minimum or no interaction with the user.

- At the moment, the issue is postponed, to avoid extra costs, but generally speaking, I'd like to know a way of doing it, preferably in a way that would be universal (not dependent on the browser).

Ideally, it would be great if QlikView standard Action "Export" could work in AJAX - after all, QlikView AJAX client is communicating with QlikView Server... I can't see any technological obstacles that should make it impossible to make this Action work... The only issue - it's outside of our control 😞

Re: Create an Excel document while using AJAX

Alexander_Thor — Tue, 26 Feb 2013 19:05:50 GMT

Ah well that simplify things quite a bit

Macros with serverside exports should work even though you use the Ajax client. Heard some reports that csv might be bugged but xls and xml should work.

Kind Regards

Alexander Karlsson

26 feb 2013 kl. 19:31 skrev "Oleg Troyansky" <qcwebmaster@qlik.com<mailto:qcwebmaster@qlik.com>>:

QlikCommunity<http://community.qlik.com/index.jspa>

Re: Create an Excel document while using AJAX

created by Oleg Troyansky<http://community.qlik.com/people/troyansky> in Integration and Extensions - View the full discussion<http://community.qlik.com/message/315775#315775>

Re: Create an Excel document while using AJAX

Oleg_Troyansky — Wed, 27 Feb 2013 15:16:51 GMT

Alex,

that's where we started, but for some reason our macro didn't work. Not even sure if it was invoked. Do you have any working examples of the macro with server-side exports?

cheers,

Oleg

Re: Create an Excel document while using AJAX

jerrysvensson — Fri, 15 Mar 2013 14:16:36 GMT

Do you want the file to be exported after reload or user action in Ajax?

We use ServersideExportEx in Ajax for the client. Since macros in Ajax is run serverside saving the resulting file on the server is not a problem.

Re: Create an Excel document while using AJAX

Oleg_Troyansky — Sat, 16 Mar 2013 03:50:39 GMT

Thanks Jerry, we'll try it out. Our export needs to happen based on the user action in Ajax.

Re: Create an Excel document while using AJAX

Tue, 26 Mar 2013 03:08:41 GMT

I have a script to export to Excel running on my machine, but when I run the server does not work.
can someone help?
My script below

sFileName = "C:\\test\\fileTest.csv"

set sExportTable1 = ActiveDocument.GetSheetObject( "tbExport" )

sExportTable1.Export sFileName,","

Re: Create an Excel document while using AJAX

jerrysvensson — Tue, 26 Mar 2013 07:38:48 GMT

Hi, if run it in Ajax sFileName = "C:\\test\\fileTest.csv" will point the servers C drive.

Re: Create an Excel document while using AJAX

Wed, 27 Mar 2013 05:13:51 GMT

sorry, I misunderstood.
I change this directory to work?