Hi there,
Try this:
# Function to read data in R from Excel
FromExcel=function(yourfile,spreadsheet){
require(RODBC)
channel=odbcConnectExcel(yourfile)
sqlTables(channel)
mydata=sqlFetch(channel, spreadsheet)
attach(mydata)
mydata
}
mydata=FromExcel("C:/mydata/2008/yourfile.xls","yourspreadsheet")
mydata[1:10,1:10]
"FromExcel" is not as efficient as it could be, but it works for me every
time.
I hope this helps,
Jorge
On Sat, Apr 19, 2008 at 6:06 PM, ermimi <[EMAIL PROTECTED]> 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.
> --
> View this message in context:
> http://www.nabble.com/Read-From-EXCEL-tp16787900p16787900.html
> Sent from the R help mailing list archive at Nabble.com.
>
> ______________________________________________
> 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.
[[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.
