access excel sheet in file in r

main.r
# Step 1 - Install the readxl package
install.packages("readxl")

# Step 2 - Load the readxl package 
library(readxl)

# Step 3 - Set the working directory to the folder where the Excel file is saved
setwd("path/to/working/directory")

# Step 4 - Read the Excel file using read_excel() function
my_data <- read_excel("filename.xlsx") # Replace filename.xlsx with the name of your Excel file

# Step 5 - Manipulate and analyze the data
# Some examples:
head(my_data) # Returns the first 6 rows of the data.frame
summary(my_data) # Returns a summary of the data, including mean, median, quartiles, and range
606 chars
17 lines