0

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.

## 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")


### Development version

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

if(!require(devtools)){
install.packages("devtools")
library(devtools)
}


### 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.

GPL3