Message-ID: <971536df0901170540u29eea26di79ced8cbbb0996c7@mail.gmail.com>
Date: 2009-01-17T13:40:30Z
From: Gabor Grothendieck
Subject: reading data from Excel Spread sheet
In-Reply-To: <27f678620901160132o4d5a7a5ct2106588b6d487999@mail.gmail.com>
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.
>
>