[R] Import from excel 2007

Gabor Grothendieck ggrothendieck at gmail.com
Wed Oct 17 05:17:37 CEST 2007


Excel 2007 xlsx files are zip files that contain XML files which
define the spreadsheet -- its all readable text.  Create an
Excel 2007 xlsx file, rename its extension to .zip, unzip it
and you can look at all the constituent files using any text
editor or your browser.

On 10/16/07, Marc Schwartz <marc_schwartz at comcast.net> wrote:
> On Tue, 2007-10-16 at 14:38 +0100, Arnold Akem wrote:
> > Hey Seniors,
> >
> >   Really new to R, please has anyone imported a dataset from MS office
> > excel 2007 into R yet? It seem to be giving me hard times which I did
> > not expect as it use to go well with the previous versions.
> >
> >   Thanks in advance.
> >   arnoldo
>
>
> Office 2007 is using a new format (.xlsx, .docx, etc.) that is not yet
> compatible with most applications (including OpenOffice), since MS does
> not document it.
>
> The best thing to do is to save the Excel file as a .CSV file and then
> use read.csv() to import the data.
>
> Alternatively, save the file in the older .xls format, which will enable
> you to use the CRAN packages with functions that support it.
>
> It is possible that Prof. Ripley's RODBC package might work, but I don't
> recall any posts confirming that.
>
> HTH,
>
> Marc Schwartz
>
> ______________________________________________
> R-help at r-project.org mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide http://www.R-project.org/posting-guide.html
> and provide commented, minimal, self-contained, reproducible code.
>



More information about the R-help mailing list