reading data from Excel Spread sheet

Hi,

http://tolstoy.newcastle.edu.au/R/e2/help/06/12/6702.html

Cheers,
Thomas

venkata kirankumar schrieb:

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.

See the 'R Data Import/Export' manual (and please study the posting 
guide, which asked you to check the manuals before posting).

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

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

Kiran,
One, not very elegant way, to solve your problem is to first save the
Excel spreadsheet as a CSV file (open the Excel file in Excel and the
use file->save as CSV, i.e. xxx.CSV) and then use read.csv()
John

John David Sorkin M.D., Ph.D.
Chief, Biostatistics and Informatics
University of Maryland School of Medicine Division of Gerontology
Baltimore VA Medical Center
10 North Greene Street
GRECC (BT/18/GR)
Baltimore, MD 21201-1524
(Phone) 410-605-7119
(Fax) 410-605-7913 (Please call phone number above prior to faxing)

"venkata kirankumar" <kiran4u2all at gmail.com> 1/16/2009 4:32 AM >>>

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



Confidentiality Statement:
This email message, including any attachments, is for th...{{dropped:6}}

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

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.

 can any one suggest how to read data from Excel Spread sheet

Perhaps easiest alternative for Excel users: RExcel [1]. I would
suggest to use this bundle installer [2].

When in Excel with RExcel loaded, select your data in Excel and choose
"Put R Dataframe".
Liviu

[1] http://sunsite.univie.ac.at/rcom/
[2] http://sunsite.univie.ac.at/rcom/download/RAndFriends.distro/RAndFriendsLightSetup2081V3.0-8-1.exe

Do you know how to read?
http://www.alienetworks.com/srtest.cfm
Do you know how to write?
http://garbl.home.comcast.net/~garbl/stylemanual/e.htm#e-mail

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

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.