[R] Import from excel 2007

Richard M. Heiberger rmh at temple.edu
Tue Oct 16 18:30:23 CEST 2007

The best way to read or write Excel files is with the RExcel package.  The
development package available from 
reads both Excel 2003 and Excel 2007 files.  In this development release,
the installer is structured as an ordinary R package for R on Windows.  It
installs an Excel addin and includes complete documentation.  RExcel
provides good two-way communication between R and Excel.  The normal method
of reading an Excel file is to open the file in Excel and then send the
to R from the Excel right-click menu.

Changing formats from Excel to .CSV or anything else has the risk of
scrambling data.
Such workarounds should normally be avoided.


-----Original Message-----
From: r-help-bounces at r-project.org [mailto:r-help-bounces at r-project.org] On
Behalf Of Arnold Akem
Sent: Tuesday, October 16, 2007 09:38 AM
To: r-help at r-project.org
Subject: [R] Import from excel 2007

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.


	[[alternative HTML version deleted]]

R-help at r-project.org mailing list
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