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:
- open excel sheet
- navigate file -> options -> trust center -> trust center settings -> protected view
- un-check "enable protected view file originating internet".
- reopen files.
i haven't found permanent fix continue allow html->xls viewing within excel.
Comments
Post a Comment