Answers

• colin Posts: 15,240Questions: 1Answers: 2,599

  January 2021

  By default, it will only export the filtered rows. This example from this thread shows how to export all rows.

  For colours, see this example from this thread,

  Colin
• umaeswara Posts: 83Questions: 16Answers: 0

  January 2021

  thanks Colin, this is really helpful.
• umaeswara Posts: 83Questions: 16Answers: 0

  January 2021 edited January 2021

  btw, how do i insert other buttons here, like pdf,csv,copy etc.

  buttons: [{
        extend: 'excelHtml5',
        text: 'Mybutton',
        customize: function ( xlsx ) {
          var sheet = xlsx.xl.worksheets['sheet1.xml'];
          
          var count = 0;
          var skippedHeader = false;
          $('row c[r^="C"]', sheet).each( function () {
            if (skippedHeader) {
              var colour = $('tbody tr:eq('+parseInt(count)+') td:eq(2)').css('background-color');
              if (colour === 'rgb(255, 0, 0)') {
                $(this).attr( 's', '35' );
              }
              else if (colour === 'rgb(0, 128, 0)') {
                $(this).attr( 's', '40' );
              }
              count++;
            }
            else {
              skippedHeader = true;
            }
          });
        }
      }]
  

  Edited by Colin - Syntax highlighting. Details on how to highlight code using markdown can be found in this guide.
• colin Posts: 15,240Questions: 1Answers: 2,599

  January 2021

  At a glance that looks like it should do the trick - other examples here should also help if you are having problems.

  If no joy, we're happy to take a look, but as per the forum rules, please link to a test case - a test case that replicates the issue will ensure you'll get a quick and accurate response. Information on how to create a test case (if you aren't able to link to the page you are working on) is available here.

  Cheers,

  Colin
• umaeswara Posts: 83Questions: 16Answers: 0

  January 2021

  thanks Colin. sure, i will add example in my future queries.
  btw, i am trying to minimizing the .js files i need to include on the webpage. i see these three are certainly needed for this excel button to be visible and work. do you agree or can I reduce it further ? i removed this jszip.min.js but then my button was not visible.
  why do we need this jszip.min.js ?
  
  
  
• umaeswara Posts: 83Questions: 16Answers: 0

  January 2021

  here is the example: http://live.datatables.net/nudeyosa/1/edit
  see it doesnt show "Excel" button if I comment out jszip.min.js .
  why is that needed?
• colin Posts: 15,240Questions: 1Answers: 2,599

  January 2021

  Oh I see, thanks for the test case. Yep, you need that file as it's used to construct the download file.

  Colin
• umaeswara Posts: 83Questions: 16Answers: 0

  January 2021

  thanks colin, please check this testcase http://live.datatables.net/nudeyosa/1/edit
  i want user to have a choice for choosing filename for the exported, right now i am giving the default name. can you please help me, if i can give a choice to user to give a name when they are about to save?
• kthorngren Posts: 21,543Questions: 26Answers: 4,988

  January 2021

  According to the buttons.exportInfo() docs you can set the title with a function. Maybe that will work for your case.

  Kevin
• colin Posts: 15,240Questions: 1Answers: 2,599

  January 2021

  Yep, title as Kevin said, example here: https://datatables.net/extensions/buttons/examples/html5/filename.html

  Colin