[R] importing excel-file

John C Frain frainj at gmail.com
Wed Apr 18 19:39:06 CEST 2007


To avoid complications, save your file as comma separated and use one
of the instructions for reading delimited files.  If you are using a
comma as a decimal point you are probably using ; as a separator.  If
this is so use read.csv2.  Please see the help files for read.table.

Best Regards

John

On 18/04/07, Schmitt, Corinna <Corinna.Schmitt at igb.fraunhofer.de> wrote:
> Dear R-experts,
>
> It is a quite stupid question but please help me. I am very confuced. I
> am able to import normal txt ant mat-files to R but unable to import
> .xls-file
>
> I do not understand the online help. Can please anyone send me the
> corresponding command lines? The .xls-file is attached. In my file we
> use commas for the decimal format (example: 0,712), changes might be
> needed.
>
> Thanks, Corinna
>
>
> ______________________________________________
> 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
> and provide commented, minimal, self-contained, reproducible code.
>
>


-- 
John C Frain
Trinity College Dublin
Dublin 2
Ireland
www.tcd.ie/Economics/staff/frainj/home.html
mailto:frainj at tcd.ie
mailto:frainj at gmail.com



More information about the R-help mailing list