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.
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)
A data frame (data.frame) containing a representation of data in the ods file.
path to the ods file.
sheet to read. Either a string (the sheet name), or an integer sheet number. The default is 1.
indicating whether the file contains the names of the variables as its first line.
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".
Character vector of strings to use for missing values. By default read_ods converts blank cells to missing data.
the number of lines of the data file to skip before beginning to read data.
a switch to display formulas as formulas "SUM(A1:A3)" or as the resulting value "3"... or "8"..
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.
indicating whether the file contains the names of the rows as its first column
logical, if character columns to be converted to factors.
logical, if messages should be displayed.
for read.ods only, path to the ods file.
for read.ods only, a switch to display formulas as formulas "SUM(A1:A3)" or as the resulting value "3"... or "8"..
Chung-hong Chan chainsawtiney@gmail.com, Gerrit-Jan Schutten phonixor@gmail.com