read_xl_sheets: Read All Sheets from an Excel Workbook

In scicomptools: Tools Developed by the NCEAS Scientific Computing Support Team

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)

Arguments

file_name

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

Value

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

Examples

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

scicomptools documentation built on June 7, 2023, 5:18 p.m.