[R] Importing an Excel spreadsheet [SOLVED]

[Gregory. R. Warnes]

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