none
OpenXML Excel Sheet.xml Schema RRS feed

  • Question

  • Hello,

    I am using the 2.0 OpenXML SDK and have come across a rather frustrating issue.

    When I create an Excel Workbook in OpenXML the Sheet.xml file is created with what appears to be quite a simple schema. If I then open the Workbook in Excel and save it (without making changes) the schema is updated to the more complicated one (including shared strings and other references).

    For example...

    My App makes:

    <x:worksheet xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

    Excel changes it to:

    <worksheet xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac" mc:Ignorable="x14ac" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">

    The problem I have is that the third-party software that my application is creating these files for requires the file format that Excel produces and not the one that OpenXML seems to.

    Is there an option in OpenXML to change the schema? Do I need a different version of the SDK?

    Thanks,

    >> Jim <<

    Wednesday, June 12, 2013 10:58 AM

Answers