Read range of cells on excel import

appetizer
import data
mild spicy
Author

Ryan Garnett

Published

April 3, 2023

Description
Read a specific range of cells of an excel file
Ingredients
Package Data

readxl

sample_housing_data.xlsx


Sample Instructions

package::function("file_path/file_name.xlsx", range = "upper left cell ID:lower right cell ID")


Actual Instructions

readxl::read_excel("C:/data/sample.xlsx", range = "B2:D5")


Output

4610415 40 NA
10535174 15 NA
822639 40 NA
9037063 275 NA