如何在Excel 2011 for Mac中解析XML？ [英] How to parse XML in Excel 2011 for Mac?

问题描述

我有一些VBA代码用于从 Excel（2007年，2010年）访问各种基于XML的Web API，并且刚刚运行在Mac上运行 Excel 2011的用户即可。我开发的代码取决于对MS XML 6.0的引用，这显然在Mac上不可用。

I have some VBA code for accessing various XML-based web APIs from Excel (2007, 2010), and have just run up against a user who is on a Mac running Excel 2011. The code I've developed depends on a reference to MS XML 6.0, which apparently isn't available on the Mac.

这个似乎是一个问题其他人反而无法解决。

This seems to be a problem others have run up against with no resolution.

<有没有人知道在Mac上替换MS XML 6.0或解决方法？

1. 用户是否可以下载并安装相关的.dll？

推荐答案

一个跨平台解决方案是使用QueryTable 像这样的一个 ，这肯定比滚动你自己的xml处理程序为mac更好。

One cross-platform solution is to use a QueryTable like this one, that would certainly be better than rolling your own xml handler for the mac.

这篇关于如何在Excel 2011 for Mac中解析XML？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！