Re: [R] Reading data from xls..........please help

2010-06-18 Thread Petr PIKAL
Hi r-help-boun...@r-project.org napsal dne 18.06.2010 14:00:47: > Surely you could also save the excel spreadsheet with the relevant data as a > text file, and then read it into R as normal? > Select "save as" in Excel and then change "save as type" to "Text (Tab > delimited)(*.txt)". > > Sa

Re: [R] Reading data from xls..........please help

2010-06-18 Thread Joris Meys
If you're on windows and you never installed perl, then you don't have it. Another easy way to find out is to type "perl" in the search window under the start menu. If there's no perl.exe on your computer, you don't have it. Take a look at : http://www.perl.org/ If you download Perl, it doesn't r

Re: [R] Reading data from xls..........please help

2010-06-18 Thread Katya Mauff
Surely you could also save the excel spreadsheet with the relevant data as a text file, and then read it into R as normal? Select "save as" in Excel and then change "save as type" to "Text (Tab delimited)(*.txt)". Save it in the directory you are using in R, (or change the directory in R to w

Re: [R] Reading data from xls..........please help

2010-06-18 Thread Petr PIKAL
Hi r-help-boun...@r-project.org napsal dne 16.06.2010 22:14:33: > Thanks for your reply. Possibly I donot have perl. I am not sure although. > How I can find whether I have it? If I dont have it then where can I > download it from? Do you have Excel? If yes you can Open Excel Select data you w

Re: [R] Reading data from xls..........please help

2010-06-16 Thread Christofer Bogaso
Thanks for your reply. Possibly I donot have perl. I am not sure although. How I can find whether I have it? If I dont have it then where can I download it from? On Thu, Jun 17, 2010 at 12:57 AM, Barry Rowlingson < b.rowling...@lancaster.ac.uk> wrote: > On Wed, Jun 16, 2010 at 7:29 PM, Christofe

Re: [R] Reading data from xls..........please help

2010-06-16 Thread Barry Rowlingson
On Wed, Jun 16, 2010 at 7:29 PM, Christofer Bogaso wrote: > Can anyone help me how to read xls file into R. I have tried following > > library(gdata) > xlsfile <- file.path(.path.package('gdata'),'xls','iris.xls') > read.xls(xlsfile) > > I got following error: > Converting xls file to csv file...

Re: [R] Reading data from xls..........please help

2010-06-16 Thread Gabor Grothendieck
On Wed, Jun 16, 2010 at 2:29 PM, Christofer Bogaso wrote: > Can anyone help me how to read xls file into R. I have tried following > > library(gdata) > xlsfile <- file.path(.path.package('gdata'),'xls','iris.xls') > read.xls(xlsfile) > > I got following error: > Converting xls file to csv file...

[R] Reading data from xls..........please help

2010-06-16 Thread Christofer Bogaso
Can anyone help me how to read xls file into R. I have tried following library(gdata) xlsfile <- file.path(.path.package('gdata'),'xls','iris.xls') read.xls(xlsfile) I got following error: Converting xls file to csv file... Error in system(cmd, intern = !verbose) : perl not found Error in file.ex