Excel export creating invalid file.

Excel export creating invalid file.

jklovancjklovanc Posts: 8Questions: 2Answers: 0

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

Replies

  • allanallan Posts: 63,133Questions: 1Answers: 10,399 Site admin

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

    Thanks,
    Allan

  • jklovancjklovanc Posts: 8Questions: 2Answers: 0

    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

  • jklovancjklovanc Posts: 8Questions: 2Answers: 0

    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
      }
    },
    
  • jklovancjklovanc Posts: 8Questions: 2Answers: 0

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

  • allanallan Posts: 63,133Questions: 1Answers: 10,399 Site admin

    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

This discussion has been closed.