DataTable Export EXCEL

bug 51032

by Rodrigo Pan

HTML

<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery-mockjax/1.6.2/jquery.mockjax.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/v/dt/jszip-2.5.0/dt-1.10.18/b-1.5.2/b-html5-1.5.2/b-print-1.5.2/datatables.min.css">
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js"></script>
<script src="https://cdn.datatables.net/v/dt/jszip-2.5.0/dt-1.10.18/b-1.5.2/b-html5-1.5.2/b-print-1.5.2/datatables.min.js"></script>
<table id="tb_rgc" class="display compact cell-border textos" cellspacing="0" width="100%">
</table>

JavaScript

// AJAX emulation
$.mockjax({
    url: '/test/0',
    responseTime: 250,
    response: function(settings){
        this.responseText = { "data" : [
          { "cd" : 795, "ds" : "Abc", "v1" : 123.45, "v2" : 91234.56 }
         ,{ "cd" : 795, "ds" : "Def", "v1" : 123.45, "v2" : 91234.56 }
        ] }
    }
});

/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////

$.extend( true, $.fn.dataTable.defaults, {
   "dom":      "lBftip"
  , rowId:      "cd"
  , "scrollY":         "200px"
  , "scrollCollapse":  true
  , "lengthMenu":      [[10, 100, 500, 1000, -1], [10, 100, 500, 1000, "Todos"]]
  , "pageLength":      1000
  , "processing":      true
  , "deferRender":     true
  , buttons: true
  , select: { style: "multi", selector: "td:first-child"}
  , buttons: [ {extend:"excel"}]
  , colReorder: true
});


$('#tb_rgc').DataTable({
    "ajax": { url: "/test/0", type: "POST"},
    "columns": [
      { "data": "ds", title: "Desc." },
      { "data": "v1", title: "Val 1", render: $.fn.dataTable.render.number(".", ",", 2) },
      { "data": "v2", title: "Val 2", render: $.fn.dataTable.render.number(".", ",", 2) }
    ]
});