Re: [R] Importing an Excel spreadsheet [SOLVED]

From: Gregory. R. Warnes <greg_at_warnes.net>
Date: Fri, 21 Mar 2008 17:01:46 -0400

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



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. Received on Fri 21 Mar 2008 - 21:11:16 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 21 Mar 2008 - 21:30:24 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive