Re: [R] Importing an Excel spreadsheet [SOLVED]

2008-03-21 Thread Gregory. R. Warnes
The gdata package provides a read.xls() function that will read in an Excel file that will work on any system with Perl installed. -G On Mar 21, 2008, at 6:47AM , andy wrote: > Hans-Peter wrote: I am trying to import an *.xls spreadsheet into R. I am doing this as >> [snip] >> >>

Re: [R] Importing an Excel spreadsheet [SOLVED]

2008-03-21 Thread andy
Hans-Peter wrote: > >> I am trying to import an *.xls spreadsheet into R. I am doing this as > [snip] > > Very steep learning curve ... so appreciate your help. > > > By looking at http://www.R-project.org/posting-guide.html -> > http://cran.r-project.org/doc/manuals/R-data.pdf -> Chapter 8 Re

Re: [R] Importing an Excel spreadsheet

2008-03-21 Thread Hans-Peter
>> I am trying to import an *.xls spreadsheet into R. I am doing this as [snip] > Very steep learning curve ... so appreciate your help. By looking at http://www.R-project.org/posting-guide.html -> http://cran.r-project.org/doc/manuals/R-data.pdf -> Chapter 8 Reading Excel spreadsheets -> you ca

Re: [R] Importing an Excel spreadsheet

2008-03-21 Thread Petr PIKAL
[EMAIL PROTECTED] napsal dne 20.03.2008 23:44:05: > Bryan K Woods wrote: > > If you open the spreadsheet in Excel you can then do "Save as..." and > > select type CSV (comma-delimited text). Once you have the data in CSV > > format, you can use the R function read.csv to import the data. > > > >

Re: [R] Importing an Excel spreadsheet

2008-03-20 Thread andy
Bryan K Woods wrote: > If you open the spreadsheet in Excel you can then do "Save as..." and > select type CSV (comma-delimited text). Once you have the data in CSV > format, you can use the R function read.csv to import the data. > > Cheers, > Bryan > > andy wrote: >> Hello >> >> I am trying to

Re: [R] Importing an Excel spreadsheet

2008-03-20 Thread Bryan K Woods
If you open the spreadsheet in Excel you can then do "Save as..." and select type CSV (comma-delimited text). Once you have the data in CSV format, you can use the R function read.csv to import the data. Cheers, Bryan andy wrote: > Hello > > I am trying to import an *.xls spreadsheet into R. I

Re: [R] Importing an Excel spreadsheet

2008-03-20 Thread ken knoblauch
andy dsl.pipex.com> writes: > I am trying to import an *.xls spreadsheet into R. I am doing this as > follows: > > read.table(file("A5_DL.xls")) > So I copied it all over to a text document and tried to import that, thus: > > read.table("A5.txt") > The error I got then was: > Error in scan(file