readODS: read_ods – R documentation

Become an expert in R — Interactive courses, Cheat Sheets, certificates and more!

read_ods

read data from ods files

Description

read_ods is a function to read a single sheet from an ods file and return a data frame. read.ods always returns a list of data frames with one data frame per sheet. This is a wrapper to read_ods for backward compatibility with previous version of readODS. Please use read_ods if possible.

Usage

read_ods(
  path = NULL,
  sheet = 1,
  col_names = TRUE,
  col_types = NULL,
  na = "",
  skip = 0,
  formula_as_formula = FALSE,
  range = NULL,
  row_names = FALSE,
  strings_as_factors = FALSE,
  verbose = FALSE
)

read.ods(file = NULL, sheet = NULL, formulaAsFormula = FALSE)

Arguments

`path`	path to the ods file.
`sheet`	sheet to read. Either a string (the sheet name), or an integer sheet number. The default is 1.
`col_names`	indicating whether the file contains the names of the variables as its first line.
`col_types`	Either NULL to guess from the spreadsheet or refer to readr::type_convert to specify cols specification. NA will return a data frame with all columns being "characters".
`na`	Character vector of strings to use for missing values. By default read_ods converts blank cells to missing data.
`skip`	the number of lines of the data file to skip before beginning to read data.
`formula_as_formula`	a switch to display formulas as formulas "SUM(A1:A3)" or as the resulting value "3"... or "8"..
`range`	selection of rectangle using Excel-like cell range, such as `range = "D12:F15"` or `range = "R1C12:R6C15"`. Cell range processing is handled by the `cellranger` package.
`row_names`	indicating whether the file contains the names of the rows as its first column
`strings_as_factors`	logical, if character columns to be converted to factors.
`verbose`	logical, if messages should be displayed.
`file`	for read.ods only, path to the ods file.
`formulaAsFormula`	for read.ods only, a switch to display formulas as formulas "SUM(A1:A3)" or as the resulting value "3"... or "8"..

Value

A data frame (data.frame) containing a representation of data in the ods file.

Note

Currently, ods files that linked to external data source cannot be read. Merged cells cannot be parsed correctly.

Author(s)

Chung-hong Chan chainsawtiney@gmail.com, Gerrit-Jan Schutten phonixor@gmail.com

readODS

Read and Write ODS Files

v1.7.0

GPL-3

Authors

Gerrit-Jan Schutten, Chung-hong Chan, Thomas J. Leeper, John Foster, and other contributors

Initial release

2020-06-22