Re: [R] Import data from Excel to R

2014-09-10 Thread Kevin Wright
Most of the time I would agree with csv being the best format. _If_ you are dealing with plain ASCII text. Having spent most of yesterday with an Excel spreadsheet containing Russian letters, I can say it is quite difficult to export the data to Unicode UTF-16 tab-delimited text and then successf

Re: [R] Import data from Excel to R

2014-09-10 Thread Jeff Newmiller
Although it may seem troublesome to export to csv, I have found that every direct access library for reading Excel files seems to come with some fiddly bits that confuse new users (and can show down an experienced user). For example, XLConnect can be a headache if your files are large because it

Re: [R] Import data from Excel to R

2014-09-10 Thread John McKown
On Wed, Sep 10, 2014 at 3:51 AM, Omar André Gonzáles Díaz wrote: > The best way is to save the file as CSV... after you can simply import it > with this comand in R: > > read.csv(...) ... to know more about the read.csv comand use in R this: > ?read.csv. > > There are other packages to import EXCE

Re: [R] Import data from Excel to R

2014-09-10 Thread Omar André Gonzáles Díaz
The best way is to save the file as CSV... after you can simply import it with this comand in R: read.csv(...) ... to know more about the read.csv comand use in R this: ?read.csv. There are other packages to import EXCEL FILES, but the simplest way, its importing this as CSV. 2014-09-09 18:03 GM

Re: [R] Import data from Excel to R

2014-09-09 Thread Gabor Grothendieck
On Tue, Sep 9, 2014 at 4:48 PM, JAWADI Fredj wrote: > Hi > I am a New user of R. > Please, how to import data from Excel to R? > Thanks, > Best regards, > Fredj, > There are some ways listed here: https://web.archive.org/web/20131109195709/http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_win

Re: [R] Import data from Excel to R

2014-09-09 Thread Peter Alspach
Tena koe Fredj There are lots of ways, depending on your precise task and preference. Have you Googled 'Import data from Excel to R'? That will bring up lots of relevant hits, including the data import/export manual that ships with R. FWIW, I use RODBC and have written a simple wrapper to do

Re: [R] Import data from Excel to R

2014-09-09 Thread Ista Zahn
Read the manual. http://cran.r-project.org/doc/manuals/r-release/R-data.html#Reading-Excel-spreadsheets Best, Ista On Sep 9, 2014 6:39 PM, "JAWADI Fredj" wrote: > Hi > I am a New user of R. > Please, how to import data from Excel to R? > Thanks, > Best regards, > Fredj, > > > [[alternat