[R-gregmisc-users] SF.net SVN: r-gregmisc:[1447] trunk/gdata/man/read.xls.Rd

[<ggr...@us...>]

Revision: 1447
          http://r-gregmisc.svn.sourceforge.net/r-gregmisc/?rev=1447&view=rev
Author:   ggrothendieck2
Date:     2010-07-07 22:48:16 +0000 (Wed, 07 Jul 2010)

Log Message:
-----------
small improvements to read.xls.Rd

Modified Paths:
--------------
    trunk/gdata/man/read.xls.Rd

Modified: trunk/gdata/man/read.xls.Rd
===================================================================
--- trunk/gdata/man/read.xls.Rd	2010-06-11 03:29:12 UTC (rev 1446)
+++ trunk/gdata/man/read.xls.Rd	2010-07-07 22:48:16 UTC (rev 1447)
@@ -47,6 +47,11 @@
   \code{read.table} since the first character of all lines (including
   comment lines) will be "\"" after conversion.
 
+  If you have quotes in your data which confuse the process you may wish to use 
+  \code{read.xls(..., quote = '')}.  This will cause the quotes to be regarded
+  as data and you will have to then handle the quotes yourself after reading 
+  the file in.
+
   Caution: If you call \code{"xls2csv"} directly, is your responsibility 
   to close and delete the file after using it.
 }
@@ -85,6 +90,11 @@
    # Example specifying exact Perl path for Unix systems
    iris <- read.xls(xlsfile, perl="/usr/bin/perl")
 
+   # finding perl 
+   # (read.xls automatically calls findPerl so this is rarely needed)
+   perl <- gdata:::findPerl("perl")
+   iris <- read.xls(xlsfile, perl=perl)
+
    # read xls file from net
    nba.url <- "http://mgtclass.mgt.unm.edu/Bose/Excel/Tutorial.05/Cases/NBA.xls"
    nba <- read.xls(nba.url)


This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.