Answers

• allan Posts: 63,161Questions: 1Answers: 10,406 Site admin

  June 2023

  Looks like whatever spreadsheet program you are using (Excel?) is parsing fields by tabs rather than commas perhaps?

  Look at the CSV file in a text editor - it should be just plain text.

  I tried your example, but it didn't create a file for me. Perhaps you might want to consider using our Buttons library which has CSV export available.

  Allan
• kthorngren Posts: 21,147Questions: 26Answers: 4,918

  June 2023

  What you show is CSV formatted data. There is a comma separating each column. It looks like the spreadsheet app you are using doesn't automatically recognize this. In this case you will need to use your spreadsheet's import function to tell it to import a CSV.

  Datatables has the Buttons extension which will allow for exporting to CSV and other formats like Excel. Take a look at the examples. Maybe the Excel export button would be more appropriate if you want to open the data in a spreadsheet.

  Kevin
• llaumegui Posts: 31Questions: 5Answers: 0

  June 2023

  Thanks for your answers,yes I'm trying to download a table to open it in Excel.

  I tried to chnage my JS like this :

  $(document).ready( function () {
  
      $('#tableaufiltre').DataTable({
          order: [[0, 'desc']],
          "language": {
              "url": "//cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/French.json"
          },
          columnDefs: [
              {
                  targets: 11,
                  render: $.fn.dataTable.render.ellipsis( 20 )
              },
              ]
      });
  
      $(document).ready(function() {
          $('#tableaufiltre').DataTable( {
              dom: 'Bfrtip',
              buttons: [
                  'excel'
              ]
          } );
      } );
  });
  

  But when i reload my page without clic on the button i have this alert :
  

  Maybe I need to had some imports ?
• llaumegui Posts: 31Questions: 5Answers: 0

  June 2023

  Edit : JS Code :

  $(document).ready( function () {
  
      $('#tableaufiltre').DataTable({
          order: [[0, 'desc']],
          "language": {
              "url": "//cdn.datatables.net/plug-ins/9dcbecd42ad/i18n/French.json"
          },
          columnDefs: [
              {
                  targets: 11,
                  render: $.fn.dataTable.render.ellipsis( 20 )
              },
              ]
      });
  
      $('#tableaufiltre').DataTable( {
          dom: 'Bfrtip',
          buttons: [
              'excel'
          ]
      } );
  
  });
  
• kthorngren Posts: 21,147Questions: 26Answers: 4,918

  June 2023

  Start by following the troubleshooting steps provided at the link in the error:
  https://datatables.net/manual/tech-notes/3

  You are trying to init Datatables twice. Combine the config options into one initialization code as described in the link.

  Maybe I need to had some imports ?

  Yes, follow the installation instructions provided in the Buttons docs.

  Kevin
• allan Posts: 63,161Questions: 1Answers: 10,406 Site admin

  June 2023

  See also this section of the manual. Combine the initialisation options into a single object! Otherwise you are initialising the table twice, exactly as the error message and the tech note it links to says.

  Allan
• llaumegui Posts: 31Questions: 5Answers: 0

  June 2023

  Thanks for your answers, I hadn't even noticed that I was initializing the table twice.
  I tried to follow your instructions and ended up here:
  https://jsbin.com/depamumeje/edit?html,js,output
  I've imported two buttons and created a new DataTable button on my JS but nothing happens.
  What am I doing wrong ?
• allan Posts: 63,161Questions: 1Answers: 10,406 Site admin

  June 2023

  I've updated your page to add the correct imported here: https://jsbin.com/rirovufibo/edit?html,output . Also, you were including both Bootstrap 4 and 5 on the page, so I've dropped 4. Not sure what the intention was there.

  The best way of making sure you get the correct files for DataTables is to use the downloader.

  Allan
• llaumegui Posts: 31Questions: 5Answers: 0

  June 2023

  Okay its working by playing with imports, I can download a perfet excel table when I click on Excel button :
  https://jsbin.com/monezawupe/edit?html,js,output

  But I want to know why my button is at the bottom left of the page in my footer ? I'd like to put it above the table if possible. And If I can have the basic page selector :
  
• allan Posts: 63,161Questions: 1Answers: 10,406 Site admin

  June 2023

  It is there, because you've used:

  .appendTo( 'body' );
  

  for that element.

  You need a different selector. See the Bootstrap 5 example. Perhaps:

  table.buttons().container().appendTo($('.col-md-6:eq(0)', table.table().container()));
  

  would work for you. https://jsbin.com/monezawupe/edit?js,output .

  Allan