如何将数据从Excel导出到具有层次结构的XML [英] how to export the data from Excel to XML having a hirearchial structure

问题描述

我需要通过从excel导出数据来创建XML.

我能够导出简单的线性结构化xml(没有任何hirerarchy).但是我需要使用Hirarchy将数据导出到XML
(即带有in节的部分)
当我尝试使用Hirarchial结构时，将显示错误消息无法导出或创建Xml.工作簿中的XML映射不可导出".
请让我知道如何执行此操作.

I need to create an XML by exporting the data from excel.

I am able to export for simple linear structured xml(with out any hirearchy). But I need to export the data to an XML with Hirarchy
(i.e sections with in section)
When I try to do for the Hirarchial structure, an error message "Cannot export or create an Xml. The XML maps in the workbook are not exportable" will be shown.
Please let me know how to do this.

推荐答案

.NET具有可用于从查询的数据集中编写XML的功能，这可以是excel工作表.这可能会也可能不会有帮助.

.NET has functions that you can use to write XML from a dataset you query, which could be an excel worksheet. This may or may not help you.

这篇关于如何将数据从Excel导出到具有层次结构的XML的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！