Answers

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

  September 2019

  Hi @Bhuvana_K ,

  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
• Bhuvana_K Posts: 2Questions: 1Answers: 0

  September 2019 edited September 2019

  Hello Colin,
  I cannot add test link since is in the live site. Below is my code to export excel. Previously I have used datatable button version 1.5.2. which gave me an error then I found forum link . Based on the forum discussion I have changed my version to 1.5.4. But it is still not working
  and gives me the same error message. Please, let me know any idea about this issue even I used the version 1.5.4 .

  My code:

  (function ($) {
  
  
          $('#example').DataTable({
              pagingType: "full",
              paging: true,
              pageResize: true,
              scrollX: "100%",
              "aaSorting": [],
              dom: 'Bfrtip',
  lengthMenu: [
              [ 5, 10, 25, 50],
              [ '5 rows', '10 rows', '25 rows', '50 rows']
          ],          
      buttons: [{extend: 'excel',  
  title: 'Test' , 
        filename: 'Report',
         messageTop: 'Report generated',     
         customize: function( xlsx ) {
                  var sheet = xlsx.xl.worksheets['sheet1.xml'];   
              }
      },{
          extend:'pageLength'
      }],
  
              columnDefs: [
                  
      ]     });
      })(jQuery);
  

  Thanks for your help!

  Edited by Kevin:  Syntax highlighting. Details on how to highlight code using markdown can be found in this guide
• kthorngren Posts: 21,930Questions: 26Answers: 5,067

  September 2019

  You have a customize function but the function isn't doing anything. Try removing lines 19-21 from the above code snippet:

         customize: function( xlsx ) {
                  var sheet = xlsx.xl.worksheets['sheet1.xml'];  
              }
  

  If that doesn't help then we will need to see an example of the problem in order to help. The problem is specific to something in your environment. If you can't link to your page then please provide a test case that replicates an example of your data and the issue.
  https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

  Kevin