[R] Where is gdata?

Spencer Graves spencer.graves at structuremonitoring.com
Mon Nov 29 04:33:12 CET 2010

Hi, Stephen:

       What operating system do you have?  From the path you cite, I 
assume you are using some version of Windows.

       Wikipedia on "perl" says there are two primary version of perl 
for Windows"  Strawberry perl, which is free, open source, and 
ActivePerl, which is free but not open source.  I've been using 
Strawberry perl without any apparent problems due to the version.  When 
I removed "~Rtools/perl" from my path, it still had Strawberry perl, and 
'installXLSXsupport()' worked with my installation of Strawberry perl, 
when it had not worked with "~Rtools/perl".  You can download Strawberry 
perl from "http://strawberryperl.com".  However,  
RSiteSearch('strawberry perl') produced 0 matches, while 
RSiteSearch("ActivePerl") returned 2 matches and RSiteSearch("Active 
Perl") found 10 matches.

        After downloading and installing one of these, if 
'installXLSXsupport()' still does not work, you need to check the path:  
If 'installXLSXsupport()' does not work with Strawberry perl as the 
first perl in your path, then you may need to install an appropriate 
package from CPAN.  More than that, I cannot answer.  However, if you 
download and install one of these two versions of perl and still have 
the problem, please report what you've done and they symptoms you get to 
this list.  Also, please include "sessionInfo()" with your reply.

       Hope this helps.

On 11/28/2010 6:38 PM, Stephen Liu wrote:
> Hi Spencer,
> Win 7
> I can't find the folders RTools\perl
> perl is on C:\Users\satimis\My Document\R\win-library\2.12\gdata\perl
> Nor I can find the folder "Strawberry perl".  Can you help?  TIA
> B.R.
> Stephen L
> ________________________________
> From: Spencer Graves<spencer.graves at structuremonitoring.com>
> To: Stephen Liu<satimis at yahoo.com>
> Sent: Mon, November 29, 2010 12:58:25 AM
> Subject: Re: [R] Where is gdata?
> Hi, Stephen:  Have you solved the problem yet?  If no, see below.  Spencer
> #######################
> Hello, All:
>         Prof. Ripley suggested I remove RTools/perl from my path.  I did
> that leaving Strawberry perl.  Then everything seemed to work appropriately.
>         Thanks to all.
>         Spencer
> On 11/28/2010 7:49 AM, Gabor Grothendieck wrote:
>> On Sun, Nov 28, 2010 at 10:40 AM, Spencer Graves
>> <spencer.graves at structuremonitoring.com>   wrote:
>>>        I tried "install.packages('gregmisc')", which Stephen said he had.
>>>    Then " help(pac=gdata)" seemed to work normally.  However, when I then
>>> tried "library(gdata)", I got an error message from the the operating
>>> system, saying "perl.exe has stopped working".  I cancelled past that and
>>> got a message "gdata: Unable to load perl libaries needed by read.xls() ...
>>> Run the function 'installXLSXsupport()'".  I tried 'installXLSXsupport()'
>>> and again perl stopped working.  I quit R and tried
>>> "install.packages('gdata')" again, and it killed perl again.
>>>        Before installing 'gregmisc', I had tried install.packages('gdata') by
>>> itself.  That seemed to work.  Then I manually removed it and tried
>>> 'gregmisc', as Stephen had, and got problems I don't know how to solve.
>>>        ???
>>>        Thanks,
>>>        Spencer
>>> ##############################
>>>> library(gdata)
>>> 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.
>> Read ?installXLSXsupport

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

More information about the R-help mailing list