[R] OpenOffice ods spreadsheets in R?

Martin Rittner kmr at thegeologician.net
Sun Jul 10 02:49:34 CEST 2011


I would like to open OpenOffice (LibreOffice) .ods files in R. I've 
tried the ROpenOffice package from omegahat, but unfortunately, the 
read.ods() function attempts to use the values of the first column in a 
worksheet as row names, and thus does not allow duplicates in there 
(which, even more unfortunately, occur in my files). Also, the function 
does not allow to forward any other parameters to the called functions, 
like e.g. row.names=FALSE.
Another option read.ods() does not offer is choice of the worksheet(s) 
to open, but that's a minor issue for me.

Now, I could alter the files to fit the function. I could alter the 
function itself. But before I do any of that, I wanted to ask if someone 
has a better idea, another approach to ods-files altogether, maybe?

Thanks, Martin



More information about the R-help mailing list