如何将 Open XML 文档保存(和打开)为 Excel 文件? [英] How to save (and open) an Open XML document as Excel file?

查看：68
本文介绍了如何将 Open XML 文档保存(和打开)为 Excel 文件?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我有一个 Open XML 文档.我想知道如何将其另存为 .xlsx 文件.

I have an Open XML document. I would like to know how to save it as an .xlsx file.

我尝试打开 Excel 软件并做了 Developer ->导入 但这将我的 XML 文件打开为 Excel - 但它确实将 XML 文件打开为 XML 文档，而不是将其打开为 Open XML 文档的 Excel 版本.

I tried opening Excel software and did Developer -> Import but that opened my XML file as Excel - but it literally opened the XML file as an XML document and did not open it as an Excel version of an Open XML document.

这是我拥有的 Open XML 文档:

This is the Open XML document I have:

<?xml version="1.0"?>
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<Worksheet     ss:Name="Forecast">
<Names>
<NamedRange     ss:Name="Print_Area"/>
</Names>
<Table>
<Row>
  <Cell><Data ss:Type="String">Day1</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
  <Cell><Data ss:Type="String">Day2</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
  <Cell><Data ss:Type="String">Day3</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
  <Cell><Data ss:Type="String">Day4</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
  <Cell><Data ss:Type="String">Day5</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>

<Cell/>

  <Cell><Data ss:Type="String">NP25</Data></Cell>
  <Cell><Data ss:Type="String">NP26</Data></Cell>
  <Cell><Data ss:Type="String">NP27</Data></Cell>
  <Cell><Data ss:Type="String">NP28</Data></Cell>
  <Cell><Data ss:Type="String">NP29</Data></Cell>
  <Cell><Data ss:Type="String">NP30</Data></Cell>
</Row>

<Row>
    <Cell><Data>1</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>2</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>3</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>4</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>5</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>

  <Cell/>

    <Cell><Data>25</Data></Cell>
    <Cell><Data>26</Data></Cell>
    <Cell><Data>27</Data></Cell>
    <Cell><Data>28</Data></Cell>
    <Cell><Data>29</Data></Cell>
    <Cell><Data>30</Data></Cell>
</Row>
<Row>
    <Cell><Data>1</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>2</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>3</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>4</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>5</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>

  <Cell/>

    <Cell><Data>25</Data></Cell>
    <Cell><Data>26</Data></Cell>
    <Cell><Data>27</Data></Cell>
    <Cell><Data>28</Data></Cell>
    <Cell><Data>29</Data></Cell>
    <Cell><Data>30</Data></Cell>
</Row>
<Row>
    <Cell><Data>1</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>2</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>3</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>4</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>5</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>

  <Cell/>

    <Cell><Data>25</Data></Cell>
    <Cell><Data>26</Data></Cell>
    <Cell><Data>27</Data></Cell>
    <Cell><Data>28</Data></Cell>
    <Cell><Data>29</Data></Cell>
    <Cell><Data>30</Data></Cell>
</Row>
<Row>
    <Cell><Data>1</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>2</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>3</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>4</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>5</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>

  <Cell/>

    <Cell><Data>25</Data></Cell>
    <Cell><Data>26</Data></Cell>
    <Cell><Data>27</Data></Cell>
    <Cell><Data>28</Data></Cell>
    <Cell><Data>29</Data></Cell>
    <Cell><Data>30</Data></Cell>
</Row>
<Row>
    <Cell><Data>1</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>2</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>3</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>4</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>
    <Cell><Data>5</Data><NamedCell
  ss:Name="pRange_default"/><NamedCell     ss:Name="Print_Area"/></Cell>

  <Cell/>

    <Cell><Data>25</Data></Cell>
    <Cell><Data>26</Data></Cell>
    <Cell><Data>27</Data></Cell>
    <Cell><Data>28</Data></Cell>
    <Cell><Data>29</Data></Cell>
    <Cell><Data>30</Data></Cell>
</Row>
</Table>
</Worksheet>
</Workbook>

如您所见，Excel 导入将我的 XML 文件作为文本 XML 文档打开，而不是将其视为 OpenXML 文档.请帮忙！

As you can see Excel import opens my XML file as a literal XML document instead of treating it asn an OpenXML document. please help!

推荐答案

抱歉重播晚了.

要让 Excel 将此 xml 文件作为电子表格打开，您需要在文档属性中包含 Excel progid.

To have Excel opening this xml file as an spreadsheet, you need to include the Excel progid in the document attributes.

<?xml version="1.0"?>
<?mso-application progid="Excel.Sheet"?> <!--This is the relevant line-->
<Workbook xmlns="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet"
xmlns:html="http://www.w3.org/TR/REC-html40">
<Worksheet     ss:Name="Forecast">
..............

这篇关于如何将 Open XML 文档保存(和打开)为 Excel 文件?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！

查看全文
相关文章
其他开发最新文章
热门教程
热门工具
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆