How to directly import Excel data using R programming language?

In the R language, you can use packages like readxl or openxlsx to read Excel data. In this example, we will demonstrate how to directly read Excel data using the readxl package.

Firstly, make sure that the readxl package is installed. If it is not, you can install it using the following command:

install.packages("readxl")

Next, use the following code to read Excel data:

library(readxl)

# 读取Excel文件中的第一个表格
data <- read_excel("文件路径/文件名.xlsx", sheet = 1)

# 读取Excel文件中指定的表格
data <- read_excel("文件路径/文件名.xlsx", sheet = "表格名")

The file path/file name.xlsx is the path and name of the Excel file, and the sheet parameter is used to specify the sheet to be read, which can be either the index of the sheet (starting from 1) or the name of the sheet.

After reading the Excel data, you can further process and analyze the data.