[R] reading data from Excel Spread sheet

Pedro Mardones mardones.p at gmail.com
Fri Jan 16 15:33:34 CET 2009


....or maybe by using the xlsReadWrite package:

mydata <- read.xls("mydata.xls", sheet = 'Sheet1")


On Fri, Jan 16, 2009 at 4:32 AM, venkata kirankumar
<kiran4u2all at gmail.com> wrote:
> Hi all,
>
> I tried to read data from Excel spread sheet with using
>
> read.csv(file.choose())
> and
> read.delim(file.choose())
> but its showing                    " *ÐÏ.à.*."
>
> and also i tried with
> read.table(file.choose())
>
> then its showing             "   *      V1
>                                        1 ÐÏ\021ࡱ*   "
>
>
> can any one suggest how to read data from Excel Spread sheet
>
> thanks & regards;
>
> kiran
>
>        [[alternative HTML version deleted]]
>
>
> ______________________________________________
> R-help at 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.
>
>




More information about the R-help mailing list