Learn R Programming

scicomptools (version 1.1.1)

read_xl_sheets: Read All Sheets from an Excel Workbook

Description

Retrieves all of the sheets in a given Microsoft Excel workbook and stores them as elements in a list. Note that the guts of this function were created by the developers of `readxl::read_excel()` and we merely created a wrapper function to invoke their work more easily.

Usage

read_xl_sheets(file_name = NULL)

Value

(list) One tibble per sheet in the Excel workbook stored as separate elements in a list

Arguments

file_name

(character) Name of (and path to) the Excel workbook

Examples

Run this code
# Read in each sheet as an element in a list
read_xl_sheets(file_name = system.file("extdata", "excel_book.xlsx", package = "scicomptools"))

Run the code above in your browser using DataLab