如何将数据从Excel导出到有效的Xml?

I have an Excel table with some data that I would like to export to an Xml file.
This exported Xml needs to be valid against an Xsd.

我有一个Excel表，其中包含一些数据，我想将这些数据导出到Xml文件中。导出的Xml必须对Xsd有效。

Note that all the formatting and validation must be done inside Excel because it'll be the only tool available to the person who will do the export.

请注意，所有的格式和验证都必须在Excel中完成，因为它将是执行导出的人惟一可用的工具。

Any recommendation to get this task done?

完成这项任务有什么建议吗?

3 个解决方案

#1

Save your file in xml format from Excel. This is known as MS Office XML. Documentation (and schema) is available for both Office 2003 and 2007.

从Excel中保存xml格式的文件。这就是MS Office XML。文档(和模式)在2003年和2007年都可以使用。

#2

I know it's a very old question but just in case some one else bumps in..

我知道这是一个非常古老的问题，但只是为了防止别人撞到我。

Accepted answer is good but XMLSS is far more complicated(though it's valid XML), I thought of sharing this resource on Microsoft. It explains everything step by step.

公认的答案是好的，但是XMLSS要复杂得多(尽管它是有效的XML)，我想在Microsoft上共享此资源。它一步一步地解释一切。

Another option is to create a CSV file and then convert it into XML using XI - There was an article about it on IBM developer works which can do the job quite well.

另一种选择是创建一个CSV文件，然后使用XI将其转换为XML——有一篇关于它的文章是关于IBM developer works的，它可以很好地完成这项工作。

This Java API may also be of interest for few.

这个Java API也可能是少数人感兴趣的。

#3

two things, write a plugin for excel, or convert the excelfile to xml and create the xsd. Edit the xml in excel and you will have the validaion in excel against that.

有两件事，为excel编写一个插件，或者将excelfile转换为xml并创建xsd。在excel中编辑xml，然后在excel中使用validaion。

http://office.microsoft.com/en-us/excel/HP011429481033.aspx

#1