JS: datatables printing and exporting excel

Question

hello there guys I have a question this might be newbie question

I have a datatable in my website now I want to print or export it in excel file the problem I am getting is that the tag <tfoot></tfoot> was not included in printing and in export

this are my code:

JS:

<script type="text/javascript" class="init">
$(document).ready(function() {
  $('#example').DataTable( {
    dom: 'Bfrtip',
    buttons: [
      {
        extend: 'print',
        customize: function ( win ) {
          $(win.document.body)
            .css( 'font-size', '10pt' )
            .prepend(
              '<img src="http://datatables.net/media/images/logo-fade.png" style="position:absolute; top:0; left:0;" />'
            );

          $(win.document.body).find( 'table' )
            .addClass( 'compact' )
            .css( 'font-size', 'inherit' );
        }
      }
    ]
  } );
} );

</script>

lzagkaretos · Accepted Answer · 2018-11-10 07:44:27Z

1

You can add footer: true option.

// ...
extend: 'print',
footer: true,
// ...

For more information, take a look here.

answered Nov 10, 2018 at 7:44

lzagkaretos

2,9202 gold badges19 silver badges28 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

JS: datatables printing and exporting excel

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related