readODS (version 1.7.0)

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.