Microsoft have just released a patch/fix to MS Excel that basically prevents web exports from opening.
This has caused no end of problems for us and a suite of some of our older modules. The code we're using is your bog standard way of exported from a website to Excel via a lotusscript agent called with a URL along the lines of "nameOfExportAgent?OpenAgent". Using print statements we perform the following....
Print |Content-Type:application/vnd.ms-excel |
Print |Content-Disposition:Attachment; filename="Report.xls"|
...and then build a table, looping around your data until complete, close the table off and the excel file is handled according to your browser of choice. It may download automatically or request you save it. Either way, when you attempt to open the file it fails with a blank screen.
The only workarounds we have found so far are as follows:
- Open the file up in notepad, re-save it and close it. It will then open correctly in Excel as the untrusted signature is removed.
- Using Windows - Control Panel - Internet Options - Security tab - trusted Sites - add the domain of the site that stores the code. This works for most browsers except Internet Explorer.
- remove the Security patch - Not really an option.
Has anyone else encountered this issue and can you advise any other workarounds? We're hoping for an option that doesn't require re-writing several pieces of exporting functionality.