[R] How to read an excel data into R?

Wensui Liu liuwensui at gmail.com
Thu Jun 23 02:38:23 CEST 2005


Ling,

You might take a look at the function read.xls() in gdata library.

HTH.


On 6/22/05, Ling Jin <ljin at lbl.gov> wrote:
> Hi all,
> 
> Does anybody know the easiest way to import excel data into R? I copied
> and pasted the excel data into a txt file, and tried read.table, but R
> reported that
> 
> Error in read.table("data_support.txt", sep = " ", header = T) :
>          more columns than column names
> 
> Thanks!
> 
> Ling
> 
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
> 


-- 
WenSui Liu, MS MA
Senior Decision Support Analyst
Division of Health Policy and Clinical Effectiveness
Cincinnati Children Hospital Medical Center




More information about the R-help mailing list