Re: [R] Re ad From EXCEL

From: Tom Backer Johnsen <backer_at_psych.uib.no>
Date: Mon, 21 Apr 2008 11:11:14 +0200

ermimi wrote:
> Hello!!!
>
> I have been read a much about as read data from Excel File, but I haven´t
> found the necesary information to read the data.
> Now, I can create a channel : channel <- odbcConnectExcel("file.xls") but I
> don´t know as read the data??
>
> I hope that you could help me. Thank you very much.

You are making an attempt at the most complex way of doing this. The simplest by far is (a) to read the data from the clipboard with the read.table () function, or (b) save the spreadsheet as a .csv type file and use the same function to read the file with the appropriate arguments for separators etc.. I tend to use the latter approach.

In any case, once imported to R, the frame should be carefully checked against the contents of the spreadsheet.

Tom



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 Mon 21 Apr 2008 - 09:13:38 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 Mon 21 Apr 2008 - 09:30:29 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