Answers

• you2525 Posts: 23Questions: 5Answers: 0

  April 2020

  I don't know if it answers to your question but what i did is initialize all the tables that are needed in the excel export in the html file and then hide the ones that i don't need to be seen on the website in the js file with initComplete: function() { $('table.dataTable').hide(); }
• kthorngren Posts: 21,327Questions: 26Answers: 4,949

  April 2020

  This example shows how to add a custom button:
  https://datatables.net/extensions/buttons/examples/initialisation/custom.html

  You can add the custom code to export the tables in the order you wish.

  Kevin
• dascoco Posts: 9Questions: 4Answers: 0

  April 2020

  Thank you for the answer.

  I generally know how to add a custom button.
  My problem is how to start the excel export for a specific table.

  Taking the example from @you2525 the export is initialized for table example and the sheet for table example2 is added.

    var table = $('#example').DataTable({
      dom: 'Bftrip',
      buttons: [
        {
          extend: 'excelHtml5',
          text: 'Excel',
          customize: function( xlsx ) {
            setSheetName(xlsx, 'Calls');
            addSheet(xlsx, '#example2', 'My Sheet2', 'Summary2', '2');
          }      
        }
      ]
    });
  

  If I would know add this code for export button to example2 then the export would start with example2 in first sheet and add example in second sheet.
  Therefore I want to create a custom button which starts export with example and then adds a new sheet with example2.And attach this custom button to both tables.
• kthorngren Posts: 21,327Questions: 26Answers: 4,949

  April 2020 Answer ✓

  The problem is that Datatables automatically creates the first sheet from the table the Excel button is configured for and working with OpenXML is complicated. Probably the easiest way is to overwrite sheet1 (default sheet) with the table you want. I created a new function called replaceSheet1() and use the code that creates the new sheet then it sets the name of the sheet. Here is the updated example:
  http://live.datatables.net/zezodeyo/1/edit

  Kevin
• dascoco Posts: 9Questions: 4Answers: 0

  April 2020

  Thank you this solved the problem