How to import .ods?

r import ods gnumeric ssconvert
Thomas picture Thomas · Feb 24, 2014 · Viewed 15.3k times · Source

I'm trying to import data (.ods file) and I know how to import .csv, .xls etc. but I strand all the time. I tried it with the package Gnumeric but R tells me that the required program 'ssconvert' cannot be found.

Answer

phonixor picture phonixor · Jun 24, 2014

I wrote a package called readODS which has a function read.ods that returns ods files as data.frames (a list of data.frames, one per sheet)

It is available on CRAN, see here!

Source and bug reports here: https://github.com/chainsawriot/readODS

Related questions

How to import multiple .csv files at once?

Suppose we have a folder containing multiple data.csv files, each containing the same number of variables but each from different times. Is there a way in R to import them all simultaneously rather than having to import them all …

Read More
How do I import a CSV file in R?

I have a .csv file in my workstation. How can I open that file in R and do statistical calculation?

Read More
Quickly reading very large tables as dataframes

I have very large tables (30 million rows) that I would like to load as a dataframes in R. read.table() has a lot of convenient features, but it seems like there is a lot of logic in the implementation that …

Read More