[R] Excel File

From: Vito Ricci <vito_ricci_at_yahoo.com>
Date: Tue 13 Jul 2004 - 01:54:41 EST


Hi,

We just discussed about this matter last week; see the subject in the mailing list:

[R]Importing an Excel file

If you do not have complicated items with spaces and special characters and you want some easy copiing on fly just issue in R

read.delim("clipboard")

after selecting an area in Excel file and pressing Ctrl-C

as seggested by Petr

or you can you can use read.xls() function included in the package "gregmisc", but you must install Perl on your PC. In this way you could import MS Excel file directly in format xls, without saving it as .csv or .txt.
Bye
Vito

Hi,

How do I open an excel file in R? I have save the excel file in unicode text
format, but it is not possible to open the file in R.

/Pernilla



Diventare costruttori di soluzioni

Visitate il portale http://www.modugno.it/ e in particolare la sezione su Palese http://www.modugno.it/archivio/cat_palese.shtml



R-help@stat.math.ethz.ch mailing list
https://www.stat.math.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Tue Jul 13 02:04:05 2004

This archive was generated by hypermail 2.1.8 : Wed 03 Nov 2004 - 22:54:51 EST