Datable js library can be downloaded from
https://datatables.net/download/release
DataTables
DataTables is the core software of the DataTables project, and involves two primary files, the DataTables Javascript and CSS.js:
https://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js
css:
https://cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css
FixedHeader
The FixedHeader plug-in will freeze in place the header, footer and left and/or right most columns in a DataTable, ensuring that title information will remain always visible.js:
https://cdn.datatables.net/fixedheader/3.1.2/js/dataTables.fixedHeader.min.js
css
https://cdn.datatables.net/fixedheader/3.1.2/css/fixedHeader.dataTables.min.css
Example:
$(
'#myTable'
).DataTable( {
fixedHeader:
true
} );
FixedColumns
FixedColumns "freezes" in place the left most columns in a scrolling DataTable, to provide a guide to the end user (for example an index column).js:
https://cdn.datatables.net/fixedcolumns/3.2.2/js/dataTables.fixedColumns.min.js
css
https://cdn.datatables.net/fixedcolumns/3.2.2/css/fixedColumns.dataTables.min.css
Export pdf and excel
Example
$(document).ready(
function
() {
$(
'#example'
).DataTable( {
dom:
'Bfrtip'
,
buttons: [
'copy'
,
'csv'
,
'excel'
,
'pdf'
,
'print'
]
} );
} );
- //code.jquery.com/jquery-1.12.4.js
- https://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js
- https://cdn.datatables.net/buttons/1.2.4/js/dataTables.buttons.min.js
- //cdn.datatables.net/buttons/1.2.4/js/buttons.flash.min.js
- //cdnjs.cloudflare.com/ajax/libs/jszip/2.5.0/jszip.min.js
- //cdn.rawgit.com/bpampuch/pdfmake/0.1.24/build/pdfmake.min.js
- //cdn.rawgit.com/bpampuch/pdfmake/0.1.24/build/vfs_fonts.js
- //cdn.datatables.net/buttons/1.2.4/js/buttons.html5.min.js
- //cdn.datatables.net/buttons/1.2.4/js/buttons.print.min.js
https://datatables.net/extensions/buttons/examples/initialisation/export.html