read ODS files into R as data.frames
Branch: master
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
R
inst/template
man
tests
.Rbuildignore
.gitignore
DESCRIPTION
NAMESPACE
README.md

README.md

readODS

read ODS files into R

how it works

ODS (Open Document Spreadsheets) files are basically a zip file with all the stuff in it. The file contents.xml is a XML file containing all the numbers and formulas used in the ODS spreadsheets.

Installation

Stable version

From the CRAN with

install.packages("readODS")
library(readODS)

Development version

From github with the devtools package WARNING: THIS MAY BE UNSTABLE!

if(!require(devtools)){
    install.packages("devtools")
    library(devtools)
}
detach("package:readODS")
remove.packages("readODS")
install_github(repo="readODS", username ="chainsawriot", ref="master")
library(readODS)

Usage

read_ods("table.ods", header = TRUE) ## return only the first sheet
read_ods("multisheet.ods", sheet = 2, formula_as_formula = TRUE) ## return the second sheet with formula read as formula
read.ods("multisheet.ods") ## for backward compatibility purpose, not recommended.

Testing

Various ods files generated by LibreOffice Calc and Google Sheets have been tested. The package has been tested on Debian 8.

License

GPL3