[R] reading data from Excel Spread sheet

[John Sorkin]

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

	[[alternative HTML version deleted]]


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