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

From: andy <>
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 ->
> -> 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:


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



"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]]

______________________________________________ mailing list
PLEASE do read the posting guide
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 Please read the posting guide before posting to the list.

list of date sections of archive