exporting title in Excel (excelHtml5) doesn't work

exporting title in Excel (excelHtml5) doesn't work

cfungcfung Posts: 1Questions: 1Answers: 0

Title shows up on PDF export, but not on Excel export. There's a duplicate question from Nov 2015 that is now closed but had no answer (https://datatables.net/forums/discussion/31369). Thanks!

Code below:

$(document).ready(function() {
$('#export').DataTable( {

dom: 'Bfrtip',     
buttons: [           
     {
        extend: 'excelHtml5',
        title: 'my excel title'
     },
    {
        extend: 'pdfHtml5',
        title: 'my pdf title'
    },
    {
        extend:'print'             
    }

]

} );
} );

Answers

  • calwayNLcalwayNL Posts: 4Questions: 1Answers: 0
    edited March 2017

    deleted

  • F12MagicF12Magic Posts: 109Questions: 0Answers: 28

    If you check the documentation excelHtml5 you'll see that there is no title option available.

  • allanallan Posts: 61,665Questions: 1Answers: 10,096 Site admin

    Yeah - I think that's something that needs to be added to the Excel export. It comes up every now and then. Look out for it in 1.3.0.

    Allan

  • F12MagicF12Magic Posts: 109Questions: 0Answers: 28

    Where would that title need to go in a excel file?
    Adding an extra row above the table header, or as a real header for each page?

This discussion has been closed.