[R] reading data from Excel Spread sheet

[Gabor Grothendieck]

There are many answers to this in R but some considerations are

- what platform are you using?
- do you have access to Excel or only to the spreadsheet itself?  If you
have access to Excel is it on the same machine as R?
- is it an Excel 2003 spreadsheet (.xls) or Excel 2007 spreadsheet (.xlsx)?
- is this a one time transfer of a particular data set or will you be
transferring
numerous similar spreadsheets?
- is the spreadsheet located on your computer or does it have to be fetched
from the internet or some other place?

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.
>
>