Geek Answers Handbook

Excel 2003 XML format does not open automatically in Excel 2010 x64

I have vbscript that generates Excel files in the old Excel XML Spreadsheet 2003 format. It contains the necessary processing instructions (ie. Tag <?mso-application progid="Excel.Sheet"?>) and my users can open them in Office 2003 and Office 2007 (works in XP) by double-clicking the attachment.

Now we are testing the desktop build of Windows 7 x64 with Office 2010 x64, and this no longer works. Files simply open in IE and show basic XML. If the file is saved on the desktop, it still displays the Excel logo on the icon, but will still open in IE.

Is this a 64-bit problem or an Excel 2010 problem? Is there a fix? I think that the permanent handler may be absent or incorrectly registered in the registry, but I do not know what to add instead ...

+5
source share
1 answer

A few thoughts:

Perhaps you need to specify the Title Title tag ? This PHP code creates and opens an XML file in Excel 2016 for me:

<?php
    header('Response.ContentType = "application/vnd.ms-excel"');
    header('Content-Disposition: attachement; filename="xlxml.xml"');
    echo '<root><name>sample_name</name></root>';
    exit();
?>

This VBS demo generated an Excel file that was opened correctly in Excel 2016 for me.

A couple of other links with some related concepts:

Excel Generation (XML Table) and Excel Header Functions

Content Type for MS Office XML

XML Schema Principles

Content Configuration

0
source

More articles:


All Articles