Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Export full table

Hi All,

In our ajax client, we want to give users the possibility to export a full table to excel without showing it in the report (we want to export all the rows and display only part of them in the report). we have a large tables with thousands of rows that our clients needs and it takes a very long time to display them  (sometimes we even have time out).  we think that this may help us to deal with with that problem. I also know that macro doesn't work in Ajax.

Can someone please advise? thanks!

3 Replies
marcus_sommer

Not tested in AJAX but in IE-Plugin the export from a minimized table is the same how a normal table.

Another Possibility could be to simplify your data-model and/or expressions to reduce the calculations-effort.

- Marcus

jerrysvensson
Partner - Specialist II
Partner - Specialist II

Macros do work in Ajax, altough not all and they run serverside.

I would create a share that QVS and the users can access. Then use ServerSideExportEx to create Excelfiles.

There are examples in the API guide.

For instance:

set tb = ActiveDocument.GetSheetObject("CH01")

tb.ServerSideExportEx "\\<share>\test.xls" , ";" , 5 '0=HTML, 1=Text, 2=Bitmap, 3=XML, 4=QVD, 5=BIFF

jonathandienst
Partner - Champion III
Partner - Champion III

QV will still need to recalculate the data for the export.

It sounds like your data model may be the problem and it would be better to fix this rather than work around it. Any model with 000s of rows should not have performance problems running on desktop or server. I have many models with millions of rows that recalculate quickly on the desktop and even quicker on the server.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein