Excel是一款功能非常强大的软件,几乎可以进行任何您想要的数学或逻辑计算。Excel专家可以创建自动化复杂流程的电子表格,这对于许多企业的良好运营至关重要。
唯一的问题是数据输入可能有点繁琐,而且会占用大量时间。特别是如果您的计算依赖于定期更改的信息。您真的每次都必须手动检查并手动输入更改信息吗?
事实证明,微软(Microsoft)的人已经想到了这一点,Excel 可以直接从网站上提取信息。这(Which)意味着,如果有一个网站跟踪某种网络表格中的特定值,您可以将其插入电子表格,确保您的计算在联网计算机上打开Excel文件时是最新的.
更好的是,您可以设置自己的网站表格,也许可以使用免费的网站创建器,例如Google 协作平台(Google Sites),提供一种简单的方法来保持您共享的Excel工作表自动更新。(Excel)听起来(Sound)不错,对吧?那么让我们来看看它是如何工作的。
在
Excel中从网站(Website)中提取数据(Data)
对于本教程,我们将使用截至 2019 年 3 月的最新 Office 365 版本的Excel (March 2019)。(Excel)
首先,打开Excel并创建一个空白工作表。
现在,切换到数据( Data )工具栏。
在获取和转换数据(Get and transform data)下的此工具栏上,单击来自 Web(From Web)。3
您可以在此处粘贴所需 Web 表的站点地址。在这种情况下,我们将使用一个名为ferates.com的网站,其中列出了当前万事达卡(Mastercard)汇率表。
具体来说,我们将使用 URL https://ferates.com/mastercard/usd,它显示了这张美元汇率(US Dollar)表。该网站的表格如下所示:
将URL(URL)粘贴到相应的字段中,然后单击OK。
这将打开导航器,这是一个向您显示您选择的网站的各种组件的工具。
该工具在页面上识别了一个表格,选择它(select it)看看它是否是我们想要的。
是的!这正是我们想要的,所以现在您所要做的就是单击Load。
瞧!
该表格现在位于您的电子表格中,其中包含实时数据。您可以像使用任何其他表格一样使用它的内容,不同之处在于这些数字将始终是最新的。
Retrieve Excel Data From a Web Page Directly
Excel is an incredibly powerful piece of software that can do almost any mathematical or logical calculations you could want. Excel gurus can create spreadsheets that automate complex processеs, essential for many businessеs to operate well.
The only problem is that data entry can be a bit of a chore and a major time sink. Especially if your calculations depend on information that changes regularly. Do you really have to manually check and type changing information manually every time?
It turns out that the folks at Microsoft have
thought of this and Excel has the
ability to pull information from websites directly. Which means if there’s a
site that keep track of a particular value in a web table of some sort, you can
plug it in to your spreadsheet, ensuring that your calculations are up to date
whenever that Excel file is opened on an internet-connected computer.
Even better, you can set up a website table of your own, perhaps using a free website creator such as Google Sites, providing an easy way to keep Excel sheets you share automatically updated. Sound pretty good, right? So let’s get down to how it works.
Pulling Data From a Website in
Excel
We’re going to use the latest Office 365
version of Excel as of March 2019 for this tutorial.
First, open Excel and create a blank worksheet.
Now, switch to the Data toolbar.
On this toolbar under Get and transform data click From Web.3
You can paste the site address for the web table you want here. In this case we are going to use a site called ferates.com, which lists current tables of Mastercard exchange rates.
Specifically, we’ll use the URL https://ferates.com/mastercard/usd, which displays this table of exchange rates for the US Dollar. The table from the site looks like this:
Paste the URL into the appropriate field and click OK.
This will bring up the navigator, a tool that
shows you the various components of the website you have selected.
The tool has identified a table on the page, select it to see if it is what we want.
Yes! This is exactly what we wanted, so now all you have to do is click Load.
Lo and behold!
The table is now in your spreadsheet with live
data. You can use the contents of it just as you would any other table, with
the difference being the figures will always be up to date.