How to export the data to excel using jquery jtable in php

Question

I want to export the data to excel using jquery jtable, I have tried but I am not getting how to export the data to excel.

I have mentioned the click event in toolbar, inside that click event what are the steps I have to follow please suggest me.

$('#EmpDetResult').jtable({
    title: 'Table of people',
    paging: true,
    toolbar: {
        items: [{
            tooltip: 'Click here to export this table to excel',
            text: 'Export to Excel',
            click: function () {
              "EVENT HERE"
            }
        }]
    },
    actions: {
        listAction: 'getResult.php?formName=afscpEmp&action=test',
        updateAction:'getResult.php?formName=afscpEmp&action=test',
        deleteAction:'getResult.php?formName=afscpEmp&action=test'
    }
});

Nicolas R · Accepted Answer · 2014-08-27 14:25:13Z

1

toolbar: {
    items: [{
        Tooltip: 'Click here to export this table to excel',
        //icon: '/images/paginate.gif',
        text: 'Export to Excel',
        click: function () {
            window.location = 'getResult.php?formName=afscpEmp&action=export-excel';
            e.preventDefault();
        }
    }]
},

edited Aug 27, 2014 at 14:25

Nicolas R

14.7k2 gold badges32 silver badges61 bronze badges

answered Aug 21, 2014 at 15:03

chaya

4234 gold badges11 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to export the data to excel using jquery jtable in php

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related