3 Replies Latest reply: Aug 7, 2014 4:09 AM by Jonathan Dienst RSS

    Export full table

    Michal Man

      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!

        • Re: Export full table
          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

          • Re: Export full table
            Jerry Svensson

            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

            • Re: Export full table
              Jonathan Dienst

              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.