Answers

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

  March 2021

  This thread should help, it's asking the same thing.

  Cheers,

  Colin
• kthorngren Posts: 21,341Questions: 26Answers: 4,954

  March 2021 Answer ✓

  This thread offers another solution that may work for you.

  Kevin
• yaylitzis Posts: 6Questions: 2Answers: 0

  March 2021

  Hi @colin

  My code looks like this

  var tableLabels = $('#myTable').DataTable({
      data: ${jsonList},
      orderCellsTop: true,
      fixedHeader: true,
      scrollX: true,
      pageLength: 50,
      select: true,
      colReorder: true,
      order: [[0, "desc"]],
      dom: 'Bfrtip',
      buttons: [
          {
              extend: 'excelHtml5',
              customize: function (xlsx) {
                  var sheet = xlsx.xl.worksheets['sheet1.xml'];
                   $('row c[r^="E"]', sheet).attr( 's', '0' );
              }
          }
      ],
      columns: [
          {data: "dateTime"},
          {data: "barcode"}   
      ],
      columnDefs: [
          {targets: 0, className: 'dt-body-left'},
          {targets: 1, className: 'dt-body-left'}     
      ]
  });
  

  I can't figure out where the solution is applied to ... Could you help a little more?
  Thanks a lot!
• colin Posts: 15,240Questions: 1Answers: 2,599

  March 2021

  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
• yaylitzis Posts: 6Questions: 2Answers: 0

  March 2021

  Hi @colin,

  Thanks for your reply, I created a test case here.
• yaylitzis Posts: 6Questions: 2Answers: 0

  March 2021

  I read @kthorngren answer and solved my question!
  Thanks!