[R] Excel File

[Vito Ricci]

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