Skip to content

Instantly share code, notes, and snippets.

@robozavri
Last active May 29, 2019 06:50
Show Gist options
  • Save robozavri/1f96906a37b322c53e9efdf589de0c36 to your computer and use it in GitHub Desktop.
Save robozavri/1f96906a37b322c53e9efdf589de0c36 to your computer and use it in GitHub Desktop.
datatables excel export for laraadmin
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/buttons/1.5.2/css/buttons.dataTables.min.css"/>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.flash.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js"></script>
<!--<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/buttons/1.5.2/js/buttons.html5.min.js"></script>
<script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.print.min.js"></script>
$("#example1").DataTable({
processing: true,
serverSide: true,
ajax: "{{ url(config('laraadmin.adminRoute') . '/apply_request_dt_ajax') }}",
language: {
lengthMenu: "_MENU_",
search: "_INPUT_",
searchPlaceholder: "Search"
},
"dom": 'lBfrtip',
"buttons": [
'copy',
// 'csv',
'excel',
// 'pdf',
'print'
],
@if($show_actions)
columnDefs: [ { orderable: false, targets: [-1] }],
@endif
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment