Excel 2007/2010如何使用REST Web服务? [英] How can Excel 2007 / 2010 consume a REST web service?
问题描述
在Excel 2007/2010中使用REST Web服务有哪些选项?我可以使用XML Maps来使用基本的XML列表,但是不允许我构建一个动态URL(所以我可以包括参数)。
What options exist to consume a REST web service from within Excel 2007 / 2010? I can use XML Maps to consume a basic XML list, but that doesn't let me build a dynamic URL (so I could include parameters).
例如,我可以为Excel添加一个XML Map to http:// machine / service / level / 5 并显示值在工作簿很好 - 没有问题。真正的问题是,如何动态地更改/ 5部分的URL来从Excel中的另一个单元格?
For example, I can add an XML Map to Excel for http://machine/service/level/5 and display the values in the workbook just fine - no problem there. The real question is, how can I dynamically change the /5 part of the URL to come from another cell in excel?
这样我可以有几个单元格有什么选择(什么ID,什么名称等),并且每当这些值改变(理想情况下),将构建一个新的动态URL,并且XML地图将被刷新。
That way I can have a couple of cells that have the options (what ID, what name, etc.) and whenever those values change (ideally) a new dynamic URL would be constructed and the XML map would be refreshed.
这样的事情有可能吗?有没有人有更好的方法来采取一些参数,调用一个Web服务(REST或SOAP,我不挑剔),并将结果推回到excel进一步操纵?
Is such a thing possible? Does anyone else have a better way to take some parameters, call a web service (REST or SOAP, I'm not picky) and shove the results back into excel for further manipulation?
推荐答案
XLLoop( http://xlloop.sourceforge.net/)可以用来调用json的HTTP调用。
XLLoop (http://xlloop.sourceforge.net/) can be used to call make Json of HTTP calls.
这篇关于Excel 2007/2010如何使用REST Web服务?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!