How the readxl package reads multiple functions of excel

This article is about how the readxl package reads multiple functions of excel. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Readxl includes several functions that can read excel, which is more convenient than the xlsx package.

Readxl includes several functions that can read excel. There is no need to call java like the read.xlsx () function in the package "xlsx" ("xlsx" application needs to install "xlsxjars" and "rJava" at the same time).

For example, the function read_xlsx () of the readxl package reads xlsx

Sheet1=read_xlsx ("Cici.xlsx", sheet = 1) > sheet1# A tibble: 1 x 3 A B C 11.2.3.

Second sheet2

Sheet2=read_xlsx ("Cici.xlsx", sheet = 2) > sheet2# A tibble: 1 x 3 a b c 13.2.1.

The function of readxl package read_xls () reads xls

Sheet1=read_xls ("data.xls", sheet = 1) > sheet1# A tibble: 1 x 3 A B C 11.2.3.

And the read_excel () function of the readxl package reads xls and xlsx

Read_excel ("data.xls", sheet = 1) # A tibble: 1 x 3 A B C 11.2. 3.read_excel ("Cici.xlsx", sheet = 2) # A tibble: 1 x 3 a b c 13.2.1. Thank you for reading! This is the end of this article on "how the readxl package reads multiple functions of excel". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!