read_xl_format: Read Formatting of All Sheets in an Excel Workbook

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

Read Formatting of All Sheets in an Excel Workbook

Description

Retrieves all sheets of a Microsoft Excel workbook and identifies the formatting of each value (including column headers and blank cells).

Usage

read_xl_format(file_name = NULL)

Arguments

file_name

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

Value

(data frame) One row per cell in the dataframe with a column for each type of relevant formatting and its 'address' within the original Excel workbook

Examples

# Identify the formatting of every cell in all sheets of an Excel file
read_xl_format(file_name = system.file("extdata", "excel_book.xlsx", package = "scicomptools"))

scicomptools documentation built on Nov. 1, 2024, 1:06 a.m.