Author Topic: Exporting selected rows into Excel  (Read 2025 times)

SmithaShivakumar

  • Newbie
  • *
  • Posts: 2
    • View Profile
Exporting selected rows into Excel
« on: April 12, 2017, 07:12:15 pm »
I am looking to save a selected set of rows from a table. The saveAs function is giving me this Error: Uncaught ReferenceError: JSZip is not defined I have the FileSaver.js, I even updated it as in https://github.com/eligrey/FileSaver.js/blob/master/FileSaver.js

Can someone help me on what is wrong with this ? What could I do differently to have the rows exported to excel? I am using param query

Code: [Select]
              {                                                         
               type: 'button',
               label: "Export",
               icon: "ui-icon-arrowthickstop-1-s",

               listener: function () {

                   //filter the selected rows.
                   this.filter({
                       oper: 'replace',
                       data: [{ dataIndx: 'Selected', value: true, condition: 'equal' }]
                   })

                   Blob = this.exportData({

                       format: $("#export_format").val(),
                       zip: $("#export_zip").prop("checked"),
                       render: true
                   });

                   //reset the filter.
                   this.filter({
                       oper: 'replace',
                       data: []
                   })

                   if (typeof blob === "string") {
                       blob = new Blob([blob]);
                   }
                   saveAs(blob, "RollManager." + format);

               }
           }

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 6310
    • View Profile
Re: Exporting selected rows into Excel
« Reply #1 on: April 12, 2017, 07:29:00 pm »
Please confirm the pqgrid version.