readODS v1.6.7

0

Monthly downloads

0th

Percentile

Read and Write ODS Files

Import ODS (OpenDocument Spreadsheet) into R as a data frame. Also support writing data frame into ODS file.

Readme

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

Functions in readODS

Name Description
read_ods read data from ods files
get_num_sheet_in_ods get the number of sheets in an ods file
ods_sheets List all sheets in an ods file.
write_ods write data to ods file
No Results!

Last month downloads

Details

Type Package
Date 2018-11-25
Contact https://github.com/chainsawriot/readODS/
License GPL-3
RoxygenNote 6.1.1
NeedsCompilation no
Packaged 2018-11-26 02:04:27 UTC; chainsaw
Repository CRAN
Date/Publication 2018-11-26 05:40:03 UTC

Include our badge in your README

[![Rdoc](http://www.rdocumentation.org/badges/version/readODS)](http://www.rdocumentation.org/packages/readODS)