用于查询亚马逊网络服务的 Excel VBA 宏以获取图书数据
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/7601685/
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
Excel VBA Macro to query Amazon Web Services for Book data
提问by user971732
I have an .xcl with 500 books, title in one column, author in another. I want to query amazon web services with a vba macro to pull back amazon's listing with title, author, isbn, and most importantly publisher and year.
我有一个包含 500 本书的 .xcl，一栏为标题，另一栏为作者。我想用 vba 宏查询亚马逊网络服务，以拉回亚马逊的标题、作者、isbn 以及最重要的出版商和年份列表。
Book list - getting book details from amazon using Excel VBA barcode lookups
图书列表 - 使用 Excel VBA 条形码查找从亚马逊获取图书详细信息
http://channel9.msdn.com/coding4fun/articles/Using-the-Amazon-Web-Service
http://channel9.msdn.com/coding4fun/articles/Using-the-Amazon-Web-Service
These have me on the right path, but one searches by isbn's, and the other i dont understand.
这些让我走上了正确的道路，但一个通过 isbn 搜索，另一个我不明白。
I have very little programming experience, but am a fast learner so what do I need to do to get this to work? Otherwise I have to go line by line and search amazon individually. Please Help!
我的编程经验很少，但我学得很快，所以我需要做什么才能让它发挥作用？否则我必须逐行逐行搜索亚马逊。请帮忙！
回答by Tomamais
There is two ways to solve this issue:
有两种方法可以解决这个问题：
http://www.linhadecodigo.com.br/Artigo.aspx?id=448
http://www.linhadecodigo.com.br/Artigo.aspx?id=448
The articles are in Portuguese, but I believe that you can read it using Google Translate.
文章是葡萄牙语，但我相信您可以使用谷歌翻译阅读。
I hope it helps
我希望它有帮助
回答by TomV
Easier way would be to use automation software that offers web data extraction capabilities. Look at Automation Anywhere. You can probably set up the task and schedule it within a few minutes. Hope this helps.
-Tom
更简单的方法是使用提供 Web 数据提取功能的自动化软件。看看 Automation Anywhere。您可能可以在几分钟内设置任务并安排它。希望这可以帮助。
-汤姆
回答by JimmyPena
The ISBNDB API lets you search by keyword, ISBN, author or publisher.
ISBNDB API 可让您按关键字、ISBN、作者或出版商进行搜索。
Given your search criteria, it returns title, author, ISBN, and a host of other information.
根据您的搜索条件，它会返回标题、作者、ISBN 和许多其他信息。
