read_ods: read data from ods files

Description Usage Arguments Value Note Author(s)

View source: R/readODS.R

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

1
2
3
4
5
read_ods(path = NULL, sheet = 1, col_names = TRUE,
  col_types = NULL, na = "", skip = 0, formula_as_formula = FALSE,
  range = NULL)

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.

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 <[email protected]>, Gerrit-Jan Schutten <[email protected]>


readODS documentation built on Nov. 26, 2018, 9:06 a.m.