read_xlsx: Parse data from a xlsx file

In SheetReader: Parse xlsx Files

Parse data from a xlsx file

Description

Parse tabular data from a sheet inside a xlsx file into a data.frame

Usage

read_xlsx(
    path,
    sheet = NULL,
    headers = TRUE,
    skip_rows = 0,
    skip_columns = 0,
    num_threads = -1,
    col_types = NULL
)

Arguments

path	The path to the xlsx file that is to be parsed.
sheet	Which sheet in the file to parse. Can be either the index/position (1 = first sheet) or name. By default parses the first sheet.
headers	Whether to interpret the first row as column names.
skip_rows	How many rows should be skipped before values are read.
skip_columns	How many columns should be skipped before values are read.
num_threads	The number of threads to use for parsing. Will be automatically determined if not provided.
col_types	A named or unnamed character vector containing one of: "guess", "logical", "numeric", "date", "text". If unnamed, the types are assigned by column index (after skip_columns is applied). If named, headers must also be true and the types are assigned by column header value. By default will guess the column type based on the first non-empty cell.

Value

data.frame

Examples

exampleFile <- system.file("extdata", "multi-test.xlsx", package = "SheetReader")

# Read first sheet of the file, using first row as column names
df1 <- read_xlsx(exampleFile, sheet = 1, headers = TRUE)
head(df1)

# Read the "encoding" sheet, skipping 1 row and not using the next row as column names
df2 <- read_xlsx(exampleFile, sheet = "encoding", headers = FALSE, skip_rows = 1)
head(df2)

# Coerce the column with header "Integer" as text
df3 <- read_xlsx(exampleFile, sheet = 1, headers = TRUE, col_types=c("Integer"="text"))
head(df3)

SheetReader documentation built on June 22, 2024, 11:14 a.m.