reading data from Excel Spread sheet
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.