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 <landronimirc@gmail.com>

Cc: Gabor Grothendieck <ggrothendieck@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]]

