Data

Tools

Indexes

Applications

Experiments

Open Source Science

readODS

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

https://github.com/ropensci/readods

Science Score: 36.0%

This score indicates how likely this project is to be science-related based on various indicators:

  • ○
    CITATION.cff file
  • ✓
    codemeta.json file
    Found codemeta.json file
  • ✓
    .zenodo.json file
    Found .zenodo.json file
  • ○
    DOI references
  • ○
    Academic publication links
  • ✓
    Committers with academic emails
    1 of 18 committers (5.6%) from academic institutions
  • ○
    Institutional organization owner
  • ○
    JOSS paper metadata
  • ○
    Scientific vocabulary similarity
    Low similarity (18.1%) to scientific vocabulary

Keywords from Contributors

corpus quanteda text-analytics
Last synced: 9 months ago · JSON representation

Repository

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

Basic Info
Statistics
  • Stars: 53
  • Watchers: 4
  • Forks: 22
  • Open Issues: 7
  • Releases: 13
Created about 12 years ago · Last pushed 11 months ago
Metadata Files
Readme Changelog License Codemeta

README.Rmd 

---
output: github_document
---



```{r, include = FALSE}
knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>",
  fig.path = "man/figures/README-",
  out.width = "100%"
)
```

# readODS 


[![CRAN status](https://www.r-pkg.org/badges/version/readODS)](https://CRAN.R-project.org/package=readODS)
[![Lifecycle: stable](https://img.shields.io/badge/lifecycle-stable-brightgreen.svg)](https://lifecycle.r-lib.org/articles/stages.html#stable)
[![Codecov test coverage](https://codecov.io/gh/ropensci/readODS/branch/v2.4/graph/badge.svg)](https://app.codecov.io/gh/ropensci/readODS?branch=v2.4)
[![rOpenSci](https://badges.ropensci.org/302_status.svg)](https://github.com/ropensci/software-review/issues/386)
[![R-CMD-check](https://github.com/ropensci/readODS/actions/workflows/R-CMD-check.yaml/badge.svg)](https://github.com/ropensci/readODS/actions/workflows/R-CMD-check.yaml)


The only goal of `readODS` is to enable R to read and write OpenDocument Spreadsheet (ODS) files. This package supports both ordinary ODS and "Flat ODS" (`fods`).

## Installation

Install the latest stable version from CRAN:

```r
install.packages("readODS")
```

from R-universe:

```r
install.packages("readODS", repos = "https://ropensci.r-universe.dev")
```

Or install the development version from Github:

```r
remotes::install_github("ropensci/readODS")
```

## Usage

In almost all use cases, you only need two functions: `read_ods` and `write_ods`. Simple.

#### Reading

```{r}
library(readODS)
read_ods("starwars.ods")
```

Reading from the 2nd sheet

```{r}
read_ods("starwars.ods", sheet = 2)
```

Reading from a specific range

```{r}
read_ods("starwars.ods", sheet = 2, range = "A1:C11")
```

Reading as a dataframe
```{r}
read_ods("starwars.ods", range="Sheet1!A2:C11", as_tibble = FALSE)
```

#### Writing

```{r}
## preserve the row names
write_ods(mtcars, "mtcars.ods", row_names = TRUE)
```

Appending a sheet

```{r}
write_ods(PlantGrowth, "mtcars.ods", append = TRUE, sheet = "plant")
```

```{r}
## Default: First sheet
read_ods("mtcars.ods")
```

```{r}
read_ods("mtcars.ods", sheet = "plant", range = "A1:B10")
```

### Maximum Sheet Size

**Reading** The maximum size of sheet you can read is determined by your machine's RAM.

**Writing** You can theoretically write sheets up to 16 384 columns by 1 048 576 rows (the current maximum sheet size in Excel and LibreOffice Calc). While larger ODS files than this are valid, they are not well supported. However older version of LibreOffice [(<=7.3)](https://wiki.documentfoundation.org/Faq/Calc/022) and Excel [(<=2003)](https://support.microsoft.com/en-gb/office/use-excel-with-earlier-versions-of-excel-2fd9ffcb-6fce-485b-85af-fecfd651a5ac#:~:text=What%20it%20means%20Beginning%20with,lost%20in%20Excel%2097%2D2003.) have significantly smaller maximum sheet sizes, and so this should be considered when writing files for distribution.

### Misc

The logo of readODS is a remix of LibreOffice Calc v6.1 icon created by the Document Foundation. The original LibreOffice logo is licensed under the [Creative Commons Attribution Share-Alike 3.0 Unported License](https://wiki.documentfoundation.org/File:LibO6_MIME.svg). readODS is not a product of the Document Foundation. The logo of readODS is licensed under the [Creative Commons Attribution Share-Alike 3.0 Unported License](https://creativecommons.org/licenses/by-sa/3.0/).

The creator of this package is Gerrit-Jan Schutten. The current maintainer is Chung-hong Chan. This package benefits from contributions by Peter Brohan, Thomas J. Leeper, John Foster, Sergio Oller, Jim Hester, Stephen Watts, Arthur Katossky, Stas Malavin, Duncan Garmonsway, Mehrad Mahmoudian, Matt Kerlogue, Detlef Steuer, Michal Lauer, and Till Straube.

This package emulates the behaviours of `readxl::read_xlsx`, `writexl::write_xlsx` and `xlsx::write.xlsx`.

This package should be a silent member of `rio`, so that you don't need to care about file format any more.

### License

GPL3

### Contributing

Contributions in the form of feedback, comments, code, and bug report are welcome.

* Fork the source code, modify, and issue a [pull request](https://docs.github.com/en/github/collaborating-with-issues-and-pull-requests/creating-a-pull-request-from-a-fork).
* Issues, bug reports: [File a Github issue](https://github.com/ropensci/readODS).

Please note that this package is released with a [Contributor Code of Conduct](https://ropensci.org/code-of-conduct/). By contributing to this project, you agree to abide by its terms.

```{r, include = FALSE}
unlink("mtcars.ods")
```

Owner

  • Name: rOpenSci
  • Login: ropensci
  • Kind: organization
  • Email: info@ropensci.org
  • Location: Berkeley, CA

CodeMeta (codemeta.json) 

{
  "@context": "https://doi.org/10.5063/schema/codemeta-2.0",
  "@type": "SoftwareSourceCode",
  "identifier": "readODS",
  "description": "Read ODS (OpenDocument Spreadsheet) into R as data frame. Also support writing data frame into ODS file.",
  "name": "readODS: Read and Write ODS Files",
  "codeRepository": "https://github.com/ropensci/readODS",
  "issueTracker": "https://github.com/ropensci/readODS/issues",
  "license": "https://spdx.org/licenses/GPL-3.0",
  "version": "2.1.0",
  "programmingLanguage": {
    "@type": "ComputerLanguage",
    "name": "R",
    "url": "https://r-project.org"
  },
  "runtimePlatform": "R version 4.3.1 (2023-06-16)",
  "provider": {
    "@id": "https://cran.r-project.org",
    "@type": "Organization",
    "name": "Comprehensive R Archive Network (CRAN)",
    "url": "https://cran.r-project.org"
  },
  "author": [
    {
      "@type": "Person",
      "givenName": "Gerrit-Jan",
      "familyName": "Schutten",
      "email": "phonixor@gmail.com"
    },
    {
      "@type": "Person",
      "givenName": "Chung-hong",
      "familyName": "Chan",
      "email": "chainsawtiney@gmail.com",
      "@id": "https://orcid.org/0000-0002-6232-7530"
    },
    {
      "@type": "Person",
      "givenName": "Peter",
      "familyName": "Brohan",
      "email": "peter.brohan@gmail.com"
    },
    {
      "@type": "Person",
      "givenName": "Detlef",
      "familyName": "Steuer",
      "email": "steuer@hsu-hh.de",
      "@id": "https://orcid.org/0000-0003-2676-5290"
    },
    {
      "@type": "Person",
      "givenName": "Thomas J.",
      "familyName": "Leeper",
      "email": "thosjleeper@gmail.com",
      "@id": "https://orcid.org/0000-0003-4097-6326"
    }
  ],
  "contributor": [
    {
      "@type": "Person",
      "givenName": "John",
      "familyName": "Foster",
      "email": "john.x.foster@nab.com.au"
    },
    {
      "@type": "Person",
      "givenName": "Sergio",
      "familyName": "Oller"
    },
    {
      "@type": "Person",
      "givenName": "Jim",
      "familyName": "Hester",
      "email": "jim.hester@rstudio.com",
      "@id": "https://orcid.org/0000-0002-2739-7082"
    },
    {
      "@type": "Person",
      "givenName": "Stephen",
      "familyName": "Watts"
    },
    {
      "@type": "Person",
      "givenName": "Arthur",
      "familyName": "Katossky"
    },
    {
      "@type": "Person",
      "givenName": "Stas",
      "familyName": "Malavin"
    },
    {
      "@type": "Person",
      "givenName": "Duncan",
      "familyName": "Garmonsway"
    },
    {
      "@type": "Person",
      "givenName": "Mehrad",
      "familyName": "Mahmoudian"
    },
    {
      "@type": "Person",
      "givenName": "Matt",
      "familyName": "Kerlogue"
    },
    {
      "@type": "Person",
      "givenName": "Michal",
      "familyName": "Lauer",
      "email": "michal.lauer.25@gmail.com"
    },
    {
      "@type": "Person",
      "givenName": "Till",
      "familyName": "Straube",
      "email": "straube@geo.uni-frankfurt.de"
    },
    {
      "@type": "Person",
      "givenName": "Marcin",
      "familyName": "Kalicinski"
    }
  ],
  "copyrightHolder": [
    {
      "@type": "Person",
      "givenName": "Marcin",
      "familyName": "Kalicinski"
    }
  ],
  "maintainer": [
    {
      "@type": "Person",
      "givenName": "Chung-hong",
      "familyName": "Chan",
      "email": "chainsawtiney@gmail.com",
      "@id": "https://orcid.org/0000-0002-6232-7530"
    }
  ],
  "softwareSuggestions": [
    {
      "@type": "SoftwareApplication",
      "identifier": "spelling",
      "name": "spelling",
      "provider": {
        "@id": "https://cran.r-project.org",
        "@type": "Organization",
        "name": "Comprehensive R Archive Network (CRAN)",
        "url": "https://cran.r-project.org"
      },
      "sameAs": "https://CRAN.R-project.org/package=spelling"
    },
    {
      "@type": "SoftwareApplication",
      "identifier": "testthat",
      "name": "testthat",
      "provider": {
        "@id": "https://cran.r-project.org",
        "@type": "Organization",
        "name": "Comprehensive R Archive Network (CRAN)",
        "url": "https://cran.r-project.org"
      },
      "sameAs": "https://CRAN.R-project.org/package=testthat"
    },
    {
      "@type": "SoftwareApplication",
      "identifier": "datasets",
      "name": "datasets"
    },
    {
      "@type": "SoftwareApplication",
      "identifier": "covr",
      "name": "covr",
      "provider": {
        "@id": "https://cran.r-project.org",
        "@type": "Organization",
        "name": "Comprehensive R Archive Network (CRAN)",
        "url": "https://cran.r-project.org"
      },
      "sameAs": "https://CRAN.R-project.org/package=covr"
    },
    {
      "@type": "SoftwareApplication",
      "identifier": "knitr",
      "name": "knitr",
      "provider": {
        "@id": "https://cran.r-project.org",
        "@type": "Organization",
        "name": "Comprehensive R Archive Network (CRAN)",
        "url": "https://cran.r-project.org"
      },
      "sameAs": "https://CRAN.R-project.org/package=knitr"
    },
    {
      "@type": "SoftwareApplication",
      "identifier": "rmarkdown",
      "name": "rmarkdown",
      "provider": {
        "@id": "https://cran.r-project.org",
        "@type": "Organization",
        "name": "Comprehensive R Archive Network (CRAN)",
        "url": "https://cran.r-project.org"
      },
      "sameAs": "https://CRAN.R-project.org/package=rmarkdown"
    }
  ],
  "softwareRequirements": {
    "1": {
      "@type": "SoftwareApplication",
      "identifier": "cellranger",
      "name": "cellranger",
      "provider": {
        "@id": "https://cran.r-project.org",
        "@type": "Organization",
        "name": "Comprehensive R Archive Network (CRAN)",
        "url": "https://cran.r-project.org"
      },
      "sameAs": "https://CRAN.R-project.org/package=cellranger"
    },
    "2": {
      "@type": "SoftwareApplication",
      "identifier": "readr",
      "name": "readr",
      "version": ">= 1.2.1",
      "provider": {
        "@id": "https://cran.r-project.org",
        "@type": "Organization",
        "name": "Comprehensive R Archive Network (CRAN)",
        "url": "https://cran.r-project.org"
      },
      "sameAs": "https://CRAN.R-project.org/package=readr"
    },
    "3": {
      "@type": "SoftwareApplication",
      "identifier": "stringi",
      "name": "stringi",
      "provider": {
        "@id": "https://cran.r-project.org",
        "@type": "Organization",
        "name": "Comprehensive R Archive Network (CRAN)",
        "url": "https://cran.r-project.org"
      },
      "sameAs": "https://CRAN.R-project.org/package=stringi"
    },
    "4": {
      "@type": "SoftwareApplication",
      "identifier": "tibble",
      "name": "tibble",
      "provider": {
        "@id": "https://cran.r-project.org",
        "@type": "Organization",
        "name": "Comprehensive R Archive Network (CRAN)",
        "url": "https://cran.r-project.org"
      },
      "sameAs": "https://CRAN.R-project.org/package=tibble"
    },
    "5": {
      "@type": "SoftwareApplication",
      "identifier": "vctrs",
      "name": "vctrs",
      "version": ">= 0.4.2",
      "provider": {
        "@id": "https://cran.r-project.org",
        "@type": "Organization",
        "name": "Comprehensive R Archive Network (CRAN)",
        "url": "https://cran.r-project.org"
      },
      "sameAs": "https://CRAN.R-project.org/package=vctrs"
    },
    "6": {
      "@type": "SoftwareApplication",
      "identifier": "zip",
      "name": "zip",
      "provider": {
        "@id": "https://cran.r-project.org",
        "@type": "Organization",
        "name": "Comprehensive R Archive Network (CRAN)",
        "url": "https://cran.r-project.org"
      },
      "sameAs": "https://CRAN.R-project.org/package=zip"
    },
    "7": {
      "@type": "SoftwareApplication",
      "identifier": "R",
      "name": "R",
      "version": ">= 3.6"
    },
    "SystemRequirements": null
  },
  "fileSize": "NAKB",
  "releaseNotes": "https://github.com/ropensci/readODS/blob/master/NEWS.md",
  "readme": "https://github.com/ropensci/readODS/blob/v2.1/README.md",
  "contIntegration": [
    "https://app.codecov.io/gh/ropensci/readODS?branch=v2.1",
    "https://github.com/ropensci/readODS/actions/workflows/R-CMD-check.yaml"
  ],
  "developmentStatus": "https://lifecycle.r-lib.org/articles/stages.html#stable",
  "review": {
    "@type": "Review",
    "url": "https://github.com/ropensci/software-review/issues/386",
    "provider": "https://ropensci.org"
  },
  "relatedLink": "https://CRAN.R-project.org/package=readODS"
}

GitHub Events

Total
  • Create event: 9
  • Release event: 2
  • Issues event: 10
  • Delete event: 4
  • Issue comment event: 11
  • Push event: 12
  • Pull request event: 17
Last Year
  • Create event: 9
  • Release event: 2
  • Issues event: 10
  • Delete event: 4
  • Issue comment event: 11
  • Push event: 12
  • Pull request event: 17

Committers

Last synced: over 2 years ago

All Time
  • Total Commits: 234
  • Total Committers: 18
  • Avg Commits per committer: 13.0
  • Development Distribution Score (DDS): 0.261
Past Year
  • Commits: 110
  • Committers: 5
  • Avg Commits per committer: 22.0
  • Development Distribution Score (DDS): 0.164
Top Committers
Name Email Commits
chainsawriot c****y@g****m 173
phonixor p****r@g****m 28
Peter 4****n 14
Michal Lauer m****5@g****m 2
Matt Kerlogue m****e@m****m 2
Joris Muller c****k@f****r 2
John Foster j****r@n****u 2
Stas Malavin s****n@g****m 1
Mehrad Mahmoudian m****n@g****m 1
Arthur Katossky a****y@f****r 1
Sergio Oller s****r@g****m 1
pbrohan p****n@g****m 1
Till g****b@k****t 1
scwatts s****2@s****u 1
Duncan Garmonsway d****y@d****k 1
gerrit-jan schutten g****n 1
Jim Hester j****r@g****m 1
Thomas J. Leeper t****r@g****m 1
Committer Domains (Top 20 + Academic)
free.fr: 2 digital.cabinet-office.gov.uk: 1 student.unimelb.edu.au: 1 ktiu.net: 1 nab.com.au: 1 me.com: 1

Issues and Pull Requests

Last synced: 10 months ago

All Time
  • Total issues: 111
  • Total pull requests: 86
  • Average time to close issues: 9 months
  • Average time to close pull requests: about 1 month
  • Total issue authors: 51
  • Total pull request authors: 19
  • Average comments per issue: 2.39
  • Average comments per pull request: 0.69
  • Merged pull requests: 80
  • Bot issues: 0
  • Bot pull requests: 0
Past Year
  • Issues: 2
  • Pull requests: 2
  • Average time to close issues: 13 days
  • Average time to close pull requests: 9 days
  • Issue authors: 2
  • Pull request authors: 1
  • Average comments per issue: 5.0
  • Average comments per pull request: 0.0
  • Merged pull requests: 2
  • Bot issues: 0
  • Bot pull requests: 0
View more stats
Top Authors
Issue Authors
  • chainsawriot (52)
  • phonixor (6)
  • ghost (3)
  • pufcan (2)
  • Deleetdk (2)
  • pbrohan (2)
  • mattkerlogue (2)
  • katossky (2)
  • mayeulk (2)
  • Robinlovelace (2)
  • MichaelChirico (2)
  • arnyeinstein (1)
  • byrongibby (1)
  • hector1980 (1)
  • mafw (1)
Pull Request Authors
  • chainsawriot (67)
  • pbrohan (5)
  • mattkerlogue (2)
  • olivroy (2)
  • drjxf (2)
  • MichalLauer (2)
  • summerrj (1)
  • flaviobello (1)
  • mmahmoudian (1)
  • basilrabi (1)
  • stas-malavin (1)
  • ktiu (1)
  • cochennec (1)
  • scwatts (1)
  • nacnudus (1)
Top Labels
Issue Labels
bug (18) v2.1 (8) feature request (6) v1.7 (6) v1.8 (4) v2.2 (4) p71 (3) help wanted (3) v2.0 (3) v3.0 (2) question (1) wontfix (1) v2.4 (1)
Pull Request Labels

Packages

  • Total packages: 2
  • Total downloads:
    • cran 7,367 last-month
  • Total docker downloads: 151,959
  • Total dependent packages: 23
    (may contain duplicates)
  • Total dependent repositories: 53
    (may contain duplicates)
  • Total versions: 16
  • Total maintainers: 1
cran.r-project.org: readODS

Read and Write ODS Files

  • Versions: 14
  • Dependent Packages: 22
  • Dependent Repositories: 52
  • Downloads: 7,367 Last month
  • Docker Downloads: 151,959
Rankings
Downloads: 3.1%
Dependent repos count: 3.4%
Forks count: 3.6%
Dependent packages count: 3.8%
Average: 4.8%
Stargazers count: 6.5%
Docker downloads count: 8.5%
Maintainers (1)
chainsawtiney@gmail.com
Last synced: 10 months ago
conda-forge.org: r-readods
  • Versions: 2
  • Dependent Packages: 1
  • Dependent Repositories: 1
Rankings
Dependent repos count: 24.1%
Dependent packages count: 29.0%
Average: 32.4%
Forks count: 36.6%
Stargazers count: 40.0%
Last synced: 10 months ago

Dependencies

DESCRIPTION cran
  • cellranger * imports
  • purrr * imports
  • readr >= 1.2.1 imports
  • stringi * imports
  • utils * imports
  • xml2 >= 1.3.2 imports
  • covr * suggests
  • datasets * suggests
  • dplyr * suggests
  • knitr * suggests
  • rmarkdown * suggests
  • testthat * suggests
.github/workflows/R-CMD-check.yaml actions
  • actions/checkout v3 composite
  • r-lib/actions/check-r-package v2 composite
  • r-lib/actions/setup-pandoc v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite
.github/workflows/test-coverage.yaml actions
  • actions/checkout v2 composite
  • r-lib/actions/setup-r v2 composite
  • r-lib/actions/setup-r-dependencies v2 composite