get_raw_text_from_xlsx: Read Excel Sheets into List of Character Matrices

In KWB-R/kwb.readxl: Read Data From Excel Files

Description

This function reads all (given) sheets of one Excel file into a list of character matrices. The idea of this function is to return the content of the Excel sheets as pure raw text information. No type conversion is performed. Empty rows at the beginning are not skipped which is the default behaviour of read_xlsx that is called under the hood.

Usage

get_raw_text_from_xlsx(file, sheets = NULL, dbg = TRUE)

Arguments

file	full path to Excel file
sheets	name(s) of sheet(s) to be read, in a vector of character. If NULL, all sheets are read.
dbg	if TRUE, debug messages are shown

Examples

# Path to example file
file <- system.file("extdata", "example.xlsx", package = "kwb.readxl")

# Read all sheets
sheet_text <- kwb.readxl::get_raw_text_from_xlsx(file)

# Have a look at the first rows of the first sheet
head(sheet_text$sheet_01)

KWB-R/kwb.readxl documentation built on Jan. 13, 2020, 1:57 a.m.