The best way to read or write Excel files is with the RExcel package. The development package available from http://sunsite.univie.ac.at/rcom/download/devel/RExcel.installer_1.80-14.zip 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 worksheet 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. Rich -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Arnold Akem Sent: Tuesday, October 16, 2007 09:38 AM To: [email protected] 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. arnoldo --------------------------------- [[alternative HTML version deleted]] ______________________________________________ [email protected] 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. ______________________________________________ [email protected] 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.
