After export excel file from php, excel 2010 is not openning it -


i have script written in php export html table excel using mime types.

since yesterday 2016/07/20, excel 2010 not openning more file web site , notice not openning form other web site same exportation

this test code

<?php header('contenttype : application/vnd.ms-excel'); header('content-disposition : attachment;filename=test.xls'); header('pragma : no-cache');  $out = " <table>     <tr>         <td>something 1</td>         <td>something 2</td>         <td>something 3</td>         <td>something 4</td>         <td>something 5</td>     </tr> </table> ";  echo $out; ?> 

the code still working excel 2010 openning file

thanks

there recent (7/12/2016) ms excel security update. following view files in excel:

  1. open excel sheet
  2. navigate file -> options -> trust center -> trust center settings -> protected view
  3. un-check "enable protected view file originating internet".
  4. reopen files.

i haven't found permanent fix continue allow html->xls viewing within excel.


Comments