How to Export the jQuery Datatable data to PDF,Excel,CSV and Copy

View Comments

• Salam,
  hey parvez i tried your code but facing some error. I am not a coder so trying to modify demos and use for my purpose. when I export it to any format it exports only the result which is visible on current page not from the next. and when i tried to download excel format, it shows it is corrupted.
  Script of index.php

  $(document).ready(function() {
  var dataTable = $('#employee-grid').DataTable( {
  "processing": true,
  "serverSide": true,
  "ajax":{
  url :"employee-grid-data.php", // json datasource
  type: "post", // method , by default get
  error: function(){ // error handling
  $(".employee-grid-error").html("");
  $("#employee-grid").append('No data found in the server');
  $("#employee-grid_processing").css("display","none");
  }
  },

  "dom": 'lBfrtip',
  "buttons": [
  {
  extend: 'collection',
  text: 'Export',
  buttons: [
  'copy',
  'excel',
  'csv',
  'pdf',
  'print'
  ]
  }
  ],
  responsive: {
  details: {
  renderer: function ( api, rowIdx ) {
  var data = api.cells( rowIdx, ':hidden' ).eq(0).map( function ( cell ) {
  var header = $( api.column( cell.column ).header() );
  return ''+header.text()+' : '+api.cell( cell ).data()+'';
  } ).toArray().join('');
  return data ? $('').append( data ) : false;
  }
  }
  }
  });

  $("#employee-grid_filter").css("display","none"); // hiding global search box
  $('.search-input-text').on( 'keyup click', function () { // for text boxes
  var i =$(this).attr('data-column'); // getting column index
  var v =$(this).val(); // getting search input value
  dataTable.columns(i).search(v).draw();
  } );
  $('.search-input-select').on( 'change', function () { // for select box
  var i =$(this).attr('data-column');
  var v =$(this).val();
  dataTable.columns(i).search(v).draw();
  } );
  } );
  part of script of response.php:

  $query=mysqli_query($conn, $sql) or die("employee-grid-data.php: get employees");

  $totalFiltered = mysqli_num_rows($query); // when there is a search parameter then we have to modify total number filtered rows as per search result.

  $sql.=" ORDER BY ". $columns[$requestData['order'][0]['column']]." ".$requestData['order'][0]['dir']." LIMIT ".$requestData['start']." ,".$requestData['length']." "; // adding length

  $query=mysqli_query($conn, $sql) or die("employee-grid-data.php: get employees");

  $data = array();

  while( $row=mysqli_fetch_array($query) ) { // preparing an array

  $nestedData=array();

  $nestedData[] = $row["id"];

  $nestedData[] = $row["CR_Number"];

  $nestedData[] = $row["Gender"];

  $nestedData[] = $row["Age"];

  $nestedData[] = $row["Disease"];

  $nestedData[] = $row["Affected_Region"];

  $nestedData[] = $row["Abnormalities"];

  $nestedData[] = " View ";

  $nestedData[] = " Download ";

  $data[] = $nestedData;

  }

  $json_data = array(

  "draw" => intval( $requestData['draw'] ), // for every request/draw by clientside , they send a number as a parameter, when they recieve a response/data they first check the draw number, so we are sending same number in draw.

  "recordsTotal" => intval( $totalData ), // total number of records

  "recordsFiltered" => intval( $totalFiltered ), // total number of records after searching, if there is no searching then totalFiltered = totalData

  "data" => $data // total data array

  );

  echo json_encode($json_data); // send data as json format

• I dont know about issue unles i hv full source code,u can take reference from downloded source code or demo.

  • How can we export only selected rows ?

    • u need to use exportOptions of datatable, get more info from here https://datatables.net/extensions/buttons/examples/print/select.html

• You can use length option like lengthMenu: [[25, 100, -1], [25, 100, "All"]] or row selection datatable plugin

• You can use lengthMenu: [[25, 100, -1], [25, 100, "All"]] or row selection datatable plugin

• I want to add the from and to "Date" and search the data according from date and to date but i am unable to post the variable in data.php file.is this possible to post the variable in data.php file

  • yes its possible, one i ll get time , I mus

• Thanks before but maybe you want to change the download button because doesnt work

  • i have verified download link, its working fine.

• Hi,
  Is there any option to export the datatable to email client like outlook.
  Ex: Onclick of Email button, the content of jQuery DataTable should copied to outlook and from there user should send mail to whomever they want, my application is not in php.
  Any help will be really appreciated.
  Regards
  Anand

  • I do not have script, You can use core php code to read mail from exchange server and list down any table grid.

• It really blew my mind away. Very great tutorial along with the demo. Truly appreciate your work...

• you need to check datatable pdf option if any

• Hi good day! i have a question. is it possible to print or convert only 1 data from the table or database? like for example i will print or convert only one person/data. can u give me some source code? it is really helpful for me as a student. THANKYOU VERY MUCH !!!

  • sorry, We do not have a source code as per your req