Hi Steve, As I have no problem with this because I run windows, I prefere to use .txt files. But may be on your case you install xlsReadWrite (or WriteRead), because .xls file works fine for ArcGis.
Remember not use complex (like having dots) or large names because some times you get error on ArcGis. Good luck, milton On Mon, Jan 25, 2010 at 12:54 PM, Steve Murray <smurray...@hotmail.com>wrote: > > Dear all, > > I've been using R on a Mac to process some data for export to ArcMap GIS > (which only runs on Windows). ArcMap seems to require tab-delimited data (my > data are in 3 columns), so I've been using the sep="\t" argument. However, > this resulted in strange end-of-line characters when displayed on a PC. I > looked in the write.table help file to find that eol="\r\n" can be used to > get around this problem, and it does indeed prevent these unwanted > characters from appearing. > > However, the data still aren't properly recognised by ArcMap when created > on a Mac (the exact same code works fine from a PC). In ArcMap, when I > select 'Display XY Data', the X (Longitude) and Y (Latitude) columns aren't > available to select. It's as if Arc isn't correctly interpreting the output > from R - this is despite me using col.names=TRUE in the write.table command. > > Any light shed on this will be very gratefully received. > > Many thanks for your help, > > Steve > > > _________________________________________________________________ > We want to hear all your funny, exciting and crazy Hotmail stories. Tell us > now > > ______________________________________________ > R-help@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<http://www.r-project.org/posting-guide.html> > and provide commented, minimal, self-contained, reproducible code. > [[alternative HTML version deleted]] ______________________________________________ R-help@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.
