Hello @vinayprakash808,
as far as I know the read_excel variants (in several packages) do not offer a filter option.
I think it is indeed more efficient to separate the functionalities for reading and filtering in specialized packages. So use openxlsx or readxl to read the file and dplyr to do the filtering :
# create an xlsx file with the data
df <- data.frame(
stringsAsFactors = F,
Col1 = c(1,2,3),
Col2 = c("A","A","B")
)
library(openxlsx)
wb <- createWorkbook()
addWorksheet(wb, "Sheet1")
writeDataTable(wb, "Sheet1", x = df)
saveWorkbook(wb, file = "new_sd.xlsx", overwrite = TRUE)
rm(list=c('df')) # remove the data.frame df
# read from the xlsx file:
df <- readxl::read_xlsx("new_sd.xlsx",sheet="Sheet1")
# filter the data
df2 <- dplyr::filter(df,Col2=="A")
print(as.data.frame(df2)) # show it as a data.frame
#> Col1 Col2
#> 1 1 A
#> 2 2 A
Created on 2021-07-14 by the reprex package (v2.0.0)