Excel export creating invalid file.

jklovanc

When I do an excel export the file created can not be opened by Office Excel. It says "We found a problem with some content ...".
I have attached the file.https://dropbox.com/s/uleuijj49itpg2j/Confmanager%20%284%29.xlsx?dl=0

allan

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

Thanks,
Allan

jklovanc

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

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

After looking in the file I found that the HTML is there but is not being recognized by Excel 2016.

allan

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