Help with Excel cell range

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?

Hi you may try this

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

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)

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())

1 Like

This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.

If you have a query related to it or one of the replies, start a new topic and refer back with a link.