Answers

• kthorngren Posts: 20,276Questions: 26Answers: 4,765

  August 2018 Answer ✓

  This is a known issue with Buttons 1.5.2. According to other threads it should be fixed in Buttons 1.5.3 and in the Nightly versions:
  https://datatables.net/download/nightly#Buttons

  Kevin
• KateFrancesca Posts: 4Questions: 1Answers: 0

  August 2018

  Hi Kevin,
  I've tried using the nightly build and it has indeed solved the problem!
  Thanks
  Kate
• gjewells Posts: 2Questions: 0Answers: 0

  September 2018

  I'm sorry to seem so clueless, but I've tried applying the buttons 1.5.3 nightly and I'm getting no better results.... so I assume I'm doing something wrong since this thread (and others) seem to indicate they are now working great. Could one of you please post a quicky "to apply the nightly build, follow these steps". I can't seem to get past the corrupt Excel export error.
• kthorngren Posts: 20,276Questions: 26Answers: 4,765

  September 2018

  Replace your current Buttons CSS and JS with the nightly versions listed at the above link. If you used the Download Builder to build a bundle then you may need to create a new bundle without Buttons to use the nightly version. Hard to say without seeing your file includes.

  Excel file corruption could occur if you are doing some custom formatting and it is not correct. Meaning its not the issue with IE 11.

  Does your export work in other browsers?

  Kevin
• gjewells Posts: 2Questions: 0Answers: 0

  September 2018

  Yes it works in other browsers like a charm... just not IE11. Not doing anything fancy with the output (yet) so I assume that it's the known bug. I did use the download builder though, so that's likely the culprit. Thanks for the help Kevin :-)
• emmKay Posts: 5Questions: 1Answers: 0

  September 2018

  Hey guys, also having the same problem, even with the nightly build.
  Can you advise why the nightly build may not be working?

  These are the files I have included:

  <link rel="stylesheet" href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.7.2/themes/cupertino/jquery-ui.css" />
  <link href="//cdn.datatables.net/1.10.16/css/jquery.dataTables.min.css" rel="stylesheet" type="text/css" />
  <script src="https://code.jquery.com/jquery-3.3.1.js " language="javascript" type="text/javascript"></script>
  <script src="https://cdn.datatables.net/1.10.19/js/jquery.dataTables.min.js " language="javascript" type="text/javascript"></script>

      <script src="https://nightly.datatables.net/buttons/js/dataTables.buttons.min.js" language="javascript" type="text/javascript"></script> 
      <script src="https://cdnjs.cloudflare.com/ajax/libs/jszip/3.1.3/jszip.min.js " language="javascript" type="text/javascript"></script>      
      <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/pdfmake.min.js " language="javascript" type="text/javascript"></script>      
      <script src="https://cdnjs.cloudflare.com/ajax/libs/pdfmake/0.1.36/vfs_fonts.js " language="javascript" type="text/javascript"></script>      
      <script src="https://cdn.datatables.net/buttons/1.5.2/js/buttons.html5.min.js " language="javascript" type="text/javascript"></script>      
      <link href="https://nightly.datatables.net/buttons/css/buttons.dataTables.min.css" rel="Stylesheet" type="text/css" />
  

  $(document).ready(function () { var table = $('#example').DataTable( { dom: 'Bfrtip', buttons: [ 'copy', 'excel', 'pdf' ] } ); });

  Many thanks
• kthorngren Posts: 20,276Questions: 26Answers: 4,765

  September 2018

  Hey guys, also having the same problem, even with the nightly build.
  Can you advise why the nightly build may not be working?

  Are you getting the corrupt file message? If not what happens?

  Does the export work with other browsers?

  Kevin
• emmKay Posts: 5Questions: 1Answers: 0

  September 2018

  Call this crazy but I now have it working with buttons 1.5.2 (not the nightly version) The standard version https://cdn.datatables.net/buttons/1.5.2/js/dataTables.buttons.min.js

  I added a <title>blah</title> tag to my head section and the exports now work.
  If I keep the title blank as such <title></title>, the exports fail.
• emmKay Posts: 5Questions: 1Answers: 0

  September 2018 edited September 2018

  I wasn't able to export at all but I can now that I have the title tag in.
  I have put the nightly files in but I am still getting the corrupt file message.
• kthorngren Posts: 20,276Questions: 26Answers: 4,765

  September 2018

  I have put the nightly files in but I am still getting the corrupt file message.

  Does your export work with browsers other than IE 11?

  Kevin