Help with Excel cell range

[Dicey]

I want to analyze excel data sheet 1 such that row 3 is the Header and row 4 onwards is the data for the analysis.

Can someone help me with the R code for this issue?

[ganapap1]

Hi you may try this

library(readxl)
df <- read_excel(path ="C:/Users/pc/Documents/aaaa.xlsx",sheet = 'Sheet1',range = "A3:J20" )
df <- na.omit(df)

[Dicey]

Hi, thanks for your reply.

I used the slice() function to get the data cleaned.

this code was used in selecting the file and the sheet which was (1)

library("xlsx")
Sheet <- read.xlsx(file.choose(), 1, header=TRUE)

#Remove the merged rows from the dataset and rename them as Master
Master <- Sheet %>% slice(3:n())