View source: R/excel_extract.R
read_xl_format | R Documentation |
Retrieves all sheets of a Microsoft Excel workbook and identifies the formatting of each value (including column headers and blank cells).
read_xl_format(file_name = NULL)
file_name |
(character) Name of (and path to) the Excel workbook |
(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
# 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"))
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.