Re: [R] Re ad From EXCEL

2008-04-21 Thread Jorge Ivan Velez
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

Re: [R] Re ad From EXCEL

2008-04-21 Thread Lucke, Joseph F
Sent: Saturday, April 19, 2008 5:06 PM To: r-help@r-project.org Subject: [R] Re ad From EXCEL 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("f

Re: [R] Re ad From EXCEL - Question

2008-04-21 Thread Bert Gunter
difficulties? -- Bert Gunter Genentech Nonclinical Statistics -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Erich Neuwirth Sent: Sunday, April 20, 2008 2:18 AM To: r-help@r-project.org Subject: Re: [R] Re ad From EXCEL To transfer data from Excel to R

Re: [R] Re ad From EXCEL

2008-04-21 Thread Tom Backer Johnsen
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

Re: [R] Re ad From EXCEL

2008-04-20 Thread Petr PIKAL
Hi there is also a direct copy option In Excel select a portion of data you want to copy, preferably with header and press Ctrl-C Open R issue read.delim("clipboard") For inverse transfer see ?write Regards Petr [EMAIL PROTECTED] [EMAIL PROTECTED] napsal dne 20.04.2008 17:51:26: > > Than

Re: [R] Re ad From EXCEL

2008-04-20 Thread ermimi
Thank you Erich for you information, I will continue investigating about as read data from excel. Erich Neuwirth wrote: > > To transfer data from Excel to R you have a least 3 options. > RODBC is platform-independent. You can use it to read Excel files > on any platform where you have an ODBC dr

Re: [R] Re ad From EXCEL

2008-04-20 Thread Erich Neuwirth
To transfer data from Excel to R you have a least 3 options. RODBC is platform-independent. You can use it to read Excel files on any platform where you have an ODBC driver for Excel installed. xlsReadWrite is available only on Windows. It has a function read.xls which reads data from Excel worksh

[R] Re ad From EXCEL

2008-04-19 Thread ermimi
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. -- V