DataTable Excel Export

HTML

<script src="https://code.jquery.com/jquery-3.2.1.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<script src="https://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css">
<script src="https://cdn.datatables.net/buttons/1.2.4/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.2.4/js/dataTables.buttons.min.js"></script>
<link rel="stylesheet" href="https://cdn.datatables.net/buttons/1.2.4/css/buttons.dataTables.min.css">
<script src="https://cdn.rawgit.com/bpampuch/pdfmake/0.1.24/build/pdfmake.min.js"></script>
<script src="https://cdn.rawgit.com/bpampuch/pdfmake/0.1.24/build/vfs_fonts.js"></script>

<button>Destroy table</button>
    <table id="example" class="cell-border" width="100%"></table>

JavaScript

$(document).ready(function() {
		var cols = [
            { title: 'name' },
            { title: 'surname' },
            { title: 'position' },
            { title: 'office' },
            { title: 'salary' }
        ];
    var data = [
      ["Airi","Satou","Accountant","Tokyo",162000],
      ["Ashton","Cox","Junior Technical Officer","SF",86000]
      
    ];
    
    var table = $('#example').DataTable({
    	columns: [
           { title: 'name' },
            { title: 'surname' }
      ],
      data: data
    });
		
    
    $('button').on('click', function () {
    	
    
		table.destroy();
		$('#example').empty();
    
    $('#example').DataTable( {
        columns: cols,
        data: data
    } );
   });
  
} );