Importing an Excel spreadsheet [SOLVED]
The gdata package provides a read.xls() function that will read in an Excel file that will work on any system with Perl installed. -G
On Mar 21, 2008, at 6:47AM , andy wrote:
Hans-Peter wrote:
I am trying to import an *.xls spreadsheet into R. I am doing this as
[snip]
Very steep learning curve ... so appreciate your help.
By looking at http://www.R-project.org/posting-guide.html ->
http://cran.r-project.org/doc/manuals/R-data.pdf -> Chapter 8 Reading
Excel spreadsheets -> you can also find my package xlsReadWrite which
natively reads Excel files (Windows only).
Using *.csv file is probably the more common/recommended way but be
careful with 'cutted decimal places'.
--
Regards,
Hans-Peter
Thanks Hans-Peter and Petr. I did use csv, but will probably, in
future,
use Petr's suggestion about reading from the clipboard:
read.delim("clipboard")
Because as it so happens, there was way too much unnecessary data
in the
spreadsheet. Plus I am using GNU/Linux, not Windows so some approaches
won't work.
I think this is now sorted.
Many thanks
Andy
--
"If they can get you asking the wrong questions, they don't have to
worry about the answers." - Thomas Pynchon, "Gravity's Rainbow"
[[alternative HTML version deleted]]
______________________________________________ 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.
Gregory R. Warnes, Ph.D.
Associate Professor
Center for Biodefence Immune Modeling
and
Department of Biostatistics and Computational Biology
University of Rochester