In this shot, we will go over how to use the `read_excel()` method to read an Excel file in R. The **`read_excel()` method** is used to read an Excel file. In order to use this method, you first have to import the `readxl` library in your R program.

#    
## Approach
1. Install the module (optional) `install.packages("readxl")`
1. Import the module `library("readxl")`
2. Specify the `path` of the file to the `read_excel()` method
3. Read the file with `data <- read_excel("dataset.xlsx")`
4. Display the content of the file with `print(data)`


#     
## Syntax
---
```r
read_excel("path",sheet=1,col_names= TRUE,col_types=NULL,na="",skip= 0)
```
---
## Parameters
* `path`: Directory or path of excel file.
* `sheet`: Either the name of the sheet in the Excel file or index number. The default is 1.
* `col_names`: Default is `TRUE`.
  * `TRUE`: Read the first row as a file header.
  * `FALSE`: File does not have a header.
  * `Character Vector`: A character vector that contains header names.
*  `col_types`: Default is `NULL`.
   * `NULL`: Detects the type of column from the spreadsheet.
   * `Vector`: A vector that contains "blank", "numeric", "date", or "text."
*  `na`: Keeps empty cells as is, but we can specify `na` to fill empty cells. The default is `""`.
* `skip`: Number of rows to skip from start before reading a file. The default is 0.


# Install readxl package if not available
install.packages("readxl")
library("readxl") # library for read_excel() method
data <- read_excel("dataset.xlsx")
print(data)

Program#1

# library for read_excel() method
library("readxl")
# calling read_excel() method
data <- read_excel("dataset.xlsx", sheet= 1
    , col_names= TRUE, col_types= NULL, na="", skip= 0)
print(data)

Program#2

#    
## Explanation
* Program #1: To read an `Xlsx` or `Xls` file, we can use the `read_excel()` method from the `readxl` package (lines 1 and 2). We specify the necessary parameters like `path_name` or `file_name`, if the program and file are in the same directory.
* Program #2: This parameterized method will produce the same output as below. The difference is that Program #1 installs the library and Program #2 does not. Program #2 also adds more optional parameter values to the `read_excel()` method.

## Output
The code above provides `dataset.xlsx` as an argument file and produces the following output.

How to use read_excel() to read Excel files in R

Use the `read_excel()` method from the `readxl` library in R to read and display Excel file contents.

How to use read_excel() to read Excel files in R

Approach

Syntax

Parameters

Example

Explanation

Output