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@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 ______________________________________________ R-help@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.