Hi Spencer,
Download and install Strawberry perl from "http://strawberryperl.com";
Installation went through without problem.
Start R
> library(gdata)
gdata: read.xls support for 'XLS' (Excel 97-2004) files ENABLED.
gdata: read.xls support for 'XLSX' (Excel 2007+) files ENABLED.
Attaching package: 'gdata'
The following object(s) are masked from 'package:utils':
object.size
> ?read.xls
starts "Read Excel files". Thanks
B.R.
Stephen L
________________________________
From: Spencer Graves <spencer.gra...@structuremonitoring.com>
Cc: Liviu Andronic <landronim...@gmail.com>; r-help <r-help@r-project.org>
Sent: Mon, November 29, 2010 4:57:53 PM
Subject: Re: [R] Where is gdata?
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
[[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.
