How to show HTML5 Export Buttons and Length Drop Down at the same time? (DataTables 1.10.9)

glober

I have the code:

$('#example').dataTable({
                   dom: 'Bfrtip', 
                   buttons: [
                         {
                             extend: 'excelHtml5', 
                             extension: '.xlsx',
                             text: 'Excel'
                         }
                     ] 
      });

And now I have a button, but no Lenght anymore.
How can I also add Length Drop Down to my layout and keep my Export button?

tangerine

Your dom configuration needs a lowercase l - for "laughter" - for the length menu.

glober

Thanks, tangerine. You've saved me a lot of time!

mech2soft

Hi glober,
Could you share the updated code? I am into similar problem.
Thanks,

allan

Its just as @tangerine says - add the l option to dom. I've also replied to your other question on this topic.

Allan

audrine

This is awesome. Thanks Tangerine