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

From: andy <geek_show_at_dsl.pipex.com>
Date: Fri, 21 Mar 2008 10:47:55 +0000

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.
Received on Fri 21 Mar 2008 - 10:51:30 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