Hi, Stephen:
The directory "C:\Users\satimiswin764\My
Documents\R\win-library\2.12\gdata\perl" is NOT the perl interpreter but
only perl code in the gdata package for R, invoked by certain R
commands. You need to install something like "Strawberry perl", as I've
previously stated.
Spencer
On 11/29/2010 12:44 AM, Stephen Liu wrote:
Hi Liviu,
Not if you
library(gdata)
first. Then
?read.xls
should work.
Yes, I did.
I found something strange here which I can't explain.
Win 7 64bit
R 32/64 bit
Just rebooted Win 7 and R
library(gdata)
gdata: Unable to locate valid perl interpreter
gdata:
gdata: read.xls() will be unable to read Excel XLS and XLSX files
gdata: unless the 'perl=' argument is used to specify the location of a
gdata: valid perl intrpreter.
gdata:
gdata: (To avoid display of this message in the future, please ensure
gdata: perl is installed and available on the executable search path.)
gdata: Unable to load perl libaries needed by read.xls()
gdata: to support 'XLX' (Excel 97-2004) files.
gdata: Unable to load perl libaries needed by read.xls()
gdata: to support 'XLSX' (Excel 2007+) files.
gdata: Run the function 'installXLSXsupport()'
gdata: to automatically download and install the perl
gdata: libaries needed to support Excel XLS and XLSX formats.
Attaching package: 'gdata'
The following object(s) are masked from 'package:utils':
object.size
It complains.
?read.xls
starting httpd help server ... done
"Read Excel files"
Both 32 and 64 bit R worked.
If there is NO complaint on running;
library(gdata)
Then
?read.xls
can't work.
Perl seems has been installed. But I can't recall, when and how;
C:\>dir C:\Users\satimiswin764\Documents\R\win-library\2.12\gdata\
.....
11/22/2010 10:44 AM<DIR> perl
11/22/2010 10:44 AM<DIR> R
11/22/2010 10:44 AM<DIR> unitTests
11/22/2010 10:44 AM<DIR> xls
dir "C:\Users\satimiswin764\My Documents\R\win-library\2.12\gdata\perl"
11/22/2010 10:44 AM<DIR> .
11/22/2010 10:44 AM<DIR> ..
11/22/2010 10:44 AM<DIR> Archive
11/22/2010 10:44 AM 418 install_modules.pl
11/22/2010 10:44 AM<DIR> IO
11/22/2010 10:44 AM 2,710 module_tools.pl
11/22/2010 10:44 AM<DIR> OLE
11/22/2010 10:44 AM 2,019 sheetCount.pl
11/22/2010 10:44 AM 2,019 sheetNames.pl
11/22/2010 10:44 AM<DIR> Spreadsheet
11/22/2010 10:44 AM 550 supportedFormats.pl
11/22/2010 10:44 AM 114 VERSIONS
11/22/2010 10:44 AM 5,512 xls2csv.pl
11/22/2010 10:44 AM 5,512 xls2tab.pl
11/22/2010 10:44 AM 5,512 xls2tsv.pl
9 File(s) 24,366 bytes
6 Dir(s) 16,776,032,256 bytes free
B.R.
Stephen L
________________________________
From: Liviu Andronic<landronim...@gmail.com>
Cc: Gabor Grothendieck<ggrothendi...@gmail.com>; r-help<r-help@r-project.org>
Sent: Mon, November 29, 2010 2:40:16 PM
Subject: Re: [R] Where is gdata?
?read.xls
I must run ??read.xls
Not if you
library(gdata)
first. Then
?read.xls
should work.
Regards
Liviu
[[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.
--
Spencer Graves, PE, PhD
President and Chief Operating Officer
Structure Inspection and Monitoring, Inc.
751 Emerson Ct.
San José, CA 95126
ph: 408-655-4567
______________________________________________
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.