Author Topic: Excel export not working with more data  (Read 285 times)

sshede

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 18
    • View Profile
Excel export not working with more data
« on: November 18, 2020, 12:06:39 pm »
When I try export Excel (25000 Rows and 168 column ) that time my browse is crash.

 type: 'button',
                        label: "Export",
                        render: false,
                        icon: 'ui-icon-arrowthickstop-1-s',
                        listener: function () {
                            this.option("pageModel", false);
                            var colModel=this.option("colModel");
                            colModel[3].hidden = true;
                            this.option("colModel",colModel);
                            var format = $("#export_format").val(),
                                blob = this.exportData({
                                    format: format,
                                    nopqdata: true, //applicable for JSON export.
                                    render: false,
                                    nopqdata: true, //applicable for JSON export.
                                });
                            if (typeof blob === "string") {
                                blob = new Blob([blob]);
                            }
                            saveAs(blob, "AllBreakDetail." + format);
                            var colModel=this.option("colModel");
                            colModel[3].hidden = false;
                            this.option("colModel",colModel);

                            $grid.pqGrid("option", {"pageModel": pageModel});
                            $grid.pqGrid("refreshView");
                            $(".pq-grid-footer").append("<span class='allBreckCount'>Total Breaks: "+data.length+"</span>");
                        }
                    },

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 4960
    • View Profile
Re: Excel export not working with more data
« Reply #1 on: November 18, 2020, 03:53:04 pm »
[ Only Pro members may read this post. ]
« Last Edit: November 18, 2020, 03:55:06 pm by paramvir »

sshede

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 18
    • View Profile

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 4960
    • View Profile
Re: Excel export not working with more data
« Reply #3 on: November 18, 2020, 09:54:26 pm »
[ Only Pro members may read this post. ]

sshede

  • Pro Ultimate
  • Newbie
  • *
  • Posts: 18
    • View Profile
Re: Excel export not working with more data
« Reply #4 on: November 19, 2020, 12:52:33 pm »
I check your example it is working but my cell data is more. your cell data only a1 a2.
I put 35000 row in your example and check but browser not responding.

paramvir

  • Administrator
  • Hero Member
  • *****
  • Posts: 4960
    • View Profile
Re: Excel export not working with more data
« Reply #5 on: November 19, 2020, 08:07:38 pm »
[ Only Pro members may read this post. ]