将XML导入Excel(模式问题) [英] Importing XML to Excel (problem with schema)

问题描述

我以前一直在使用XML源作为Excel中的数据输入，但是以下XML文件存在问题:
http://www.ecb.int/stats/money/yc/data/fmd/download/yc_histparameters.xml

我在Excel中收到以下错误:

I've previsouly been using XML-sources as data input in Excel, but I'm having problems with the following XML file:
http://www.ecb.int/stats/money/yc/data/fmd/download/yc_histparameters.xml

I get the following error in Excel:

The following schema elements and structures cannot be mapped to a worksheet. They will not be visible in the XML Source task pane.
- any
- anyAttribute
- Substitution groups
- Abstract elements
- Recursive structures
- Mixed Content

所以问题似乎出在XML文件中的嵌套模式.


我尝试将XML文件下载到硬盘驱动器，并删除了XSD引用，



是否有人建议我如何在Excel中导入/映射XML文件?
是否可以忽略Excel?模式?
还有另一种导入数据的方法，以便在线获取XML文件的自动更新吗?

我对XML模式或解析等没有太多经验.

So the problem seems to be the nested schemas in the XML file.


I've tried downloading the XML-file to my harddrive, removing the XSD-references which at least allowed Excel to import the data.


Does anyone have a suggestion to how I can import/map the XML-file in Excel?
Is it possible to have Excel ignore the schemas?
Is there another way to import the data in order to get automatic updates from the XML file online?

I don't have much experience with XML schemas or parsing, etc.

推荐答案

我将这篇文章移至Visual Studio Tools for Office论坛.

I will move this post to Visual Studio Tools for Office forum.

这篇关于将XML导入Excel(模式问题)的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！