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.
