vba 读取xml数据的VBA基本脚本??学习这种方法的资源?
声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow
原文地址: http://stackoverflow.com/questions/2181739/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
VBA basic script for reading xml data?? Resource for learning this method?
提问by Justin
So I was just looking for basic examples of reading xml structure data with visual basic subs/scripts.
所以我只是在寻找使用可视化基本订阅/脚本读取 xml 结构数据的基本示例。
specifically, if possible, how can i take structure data of xml, read the data with some vba, and lay it into excel spreadsheets?
具体来说,如果可能的话,我如何获取xml的结构数据,用一些vba读取数据,并将其放入excel电子表格中?
or just a learning resource for this type of thing. thanks very much!
或者只是此类事情的学习资源。非常感谢!
回答by Jason Rowe
These three topics will help you get started.
这三个主题将帮助您入门。
1) Load the XML using MSXMLhint - XMLDOC.Load ("D:\folder\yourXML.xml")
1) 使用MSXML提示加载 XML - XMLDOC.Load ("D:\folder\yourXML.xml")
2) Read the data with XPathor XML navigator
2) 使用XPath或 XML 导航器读取数据
3) Build Excel Spreadsheet Using Microsoft Excel Object Model
3) 使用Microsoft Excel 对象模型构建 Excel 电子表格
回答by Dick Kusleika
http://www.dailydoseofexcel.com/archives/2009/06/16/reading-xml-files-in-vba/
http://www.dailydoseofexcel.com/archives/2009/06/16/reading-xml-files-in-vba/
http://www.dailydoseofexcel.com/archives/2010/01/21/culling-you-rss-feeds/
http://www.dailydoseofexcel.com/archives/2010/01/21/culling-you-rss-feeds/
These aren't tutorials, just a couple of examples of XML in Excel that might help you identify the objects properties and methods. The first one from 2009 was my first attempt (read: it's terrible) but the comments were helpful for me so they might be helpful for you too.
这些不是教程,只是 Excel 中的几个 XML 示例,可以帮助您识别对象的属性和方法。2009 年的第一个是我的第一次尝试(阅读:这太糟糕了)但是评论对我有帮助,所以它们也可能对你有帮助。