Replies

• allan Posts: 61,650Questions: 1Answers: 10,094 Site admin

  June 2016

  Could you give me a link to the table that is being used to create this file please?

  Thanks,
  Allan
• jklovanc Posts: 8Questions: 2Answers: 0

  June 2016

  It is in development on my test vm so is not externally available. Here is the link to the CSV that works fine.
  https://www.dropbox.com/s/6doqzlx9ziaodyu/Confmanager%20%288%29.csv?dl=0
• jklovanc Posts: 8Questions: 2Answers: 0

  July 2016

  I found the problem in that one of the columns had invalid HTML. The offending data was "city<". When I removed the "<" it worked. Will the exports always have issues with anything resembling tags? I have found that any column with html in it does not appear. I tried the following options but it makes no difference.

  {
     extend: 'excel',
     filename: 'Users_All',
     text: 'Excel All',
     exportOptions: {
        decodeEntities: true,
        stripHtml: false
    }
  },
  
• jklovanc Posts: 8Questions: 2Answers: 0

  July 2016

  After looking in the file I found that the HTML is there but is not being recognized by Excel 2016.
• allan Posts: 61,650Questions: 1Answers: 10,094 Site admin

  July 2016

  Thanks for your findings. This issue is actually being tracked by this thread - I've just not had a chance to look into addressing the issue yet I'm afraid. I hope to do so soon.

  Allan