Answers

• rf1234 Posts: 2,805Questions: 85Answers: 406

  August 2022

  This thread might help you out.
  https://datatables.net/forums/discussion/comment/167672/
  Warning: Customizing the client side Excel export can be very cumbersome and complex! Data tables does have some styles built in but you may end up having to create your own, for example
• allan Posts: 61,642Questions: 1Answers: 10,093 Site admin

  August 2022

  The export gets it's data from the buttons.exportData() method. Which by default will strip HTML and new lines.

  What you want to do is set the stripNewlines option to false for the exportOptions object in your export button:

  {
    extend: 'copy',
    exportOptions: {
      stripNewlines: false
    }
  },
  

  Allan
• guidols Posts: 38Questions: 14Answers: 1

  August 2022 edited August 2022

  I added, in my html data, the character that Excel uses to add a new line in a cell, i.e. char(10).

  But there is still a problem: the user creates the Excel using the buttons and, after opening it, he needs to press the "wrap text" button in the column containing the wrapped data:

  

  Without doing so, the data is not wrapped.

  Is there a way to create the Excel and "forcing" wrapping data?

  Please see this similar problem and solution (non related to DataTables):

  "After you supply text you should set the cell's IsTextWrapped style to true".

  Thanks!
• kthorngren Posts: 20,267Questions: 26Answers: 4,764

  August 2022 edited August 2022 Answer ✓

  This thread discusses one option.

  Kevin
• guidols Posts: 38Questions: 14Answers: 1

  August 2022

  Thanks Kevin!

  This will do the trick (where "F" is the desired column):

  $('row c[r^="F"]', sheet).attr('s', '55');