[R-sig-Geo] excel to ascii

[Michael Hewson]

At the risk of missing the big picture - wouldn't you just save from within excel as ascii txt?

-----Original Message-----
From: r-sig-geo-bounces at r-project.org [mailto:r-sig-geo-bounces at r-project.org] On Behalf Of Tomislav Hengl
Sent: Sunday, 7 October 2012 7:16 PM
To: alemante zd
Cc: r-sig-geo at r-project.org
Subject: Re: [R-sig-Geo] excel to ascii


I use the read.xls command from the gdata package [http://cran.r-project.org/web/packages/gdata/] to read XLS files to R. 
Works without a problem, but you need to get and locate Perl on your OS. 
Here is an example:

 > library(gdata)
## perl <- gdata:::findPerl("perl")
## Did not work :(
 > perl = "C:/Perl64/bin/perl.exe"
 > prof <- read.xls("prof.xls", perl=perl)


On 05/10/2012 14:34, alemante zd wrote:
> Dear all,
>
> Is here anyway, (perhaps outside R) to convert an excel file into an 
> ascii one? I was trying to read one into R but I could not.
> many thanks
> minti
>

_______________________________________________
R-sig-Geo mailing list
R-sig-Geo at r-project.org
https://stat.ethz.ch/mailman/listinfo/r-sig-geo