Excel is another popular tool used to store and analyze data. Of course, one can convert Excel files to CSV files or other text formats by using Excel. Alternatively, to simplify the process, you can use install and load the xlsx package to read and process Excel data in R.
In this recipe, you need to prepare your environment with R installed and a computer that can access the Internet.
Please perform the following steps to read Excel documents:
First, install and load the
xlsxpackage:> install.packages("xlsx") > library(xlsx)
Access www.data.worldbank.org/topic/economy-and-growth to find world economy indicator data in Excel:
Figure 6: World economy indicator
Download world economy indicator data from the following URL using
download.file:> download.file("http://api.worldbank.org/v2/en/topic/3?downloadformat=excel", "worldbank.xls", mode="wb")Examine the downloaded file with Excel (or Open Office):
Figure 7: Using Excel to examine...
