Kind of unrelated, but I've found the package xlsReadWrite really
helpful to read xls files (writing is a bit limited, but not more than
gdata, or at least I think)
It might be a good alternative.
Ivan
Le 4/7/2010 13:36, Gabor Grothendieck a écrit :
There are some known problems with reading Excel files in the CRAN
version of gdata. There are workarounds posted in the gdata section
of this R wiki page:
http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows
On Wed, Apr 7, 2010 at 4:46 AM, Olivier ETERRADOSSI
<olivier.eterrado...@mines-ales.fr> wrote:
Hello eveRybody (and probably special regards to Gabor G....),
I recently upgraded from R-2.9.2-win32 to R-10.1.0-win32, and I'm using
Windows XP Professional 2002 with service pack 3 on a PC with IntelCore Duo
CPU@ 3.00 GHz.
Last time I used it (some weeks ago, before upgrading), one of my scripts
(including the two lines cited below) used to run OK.
When I ran it yesterday evening (after upgrading), I get the following
message...
if
(test){file1<-"\\\\computername\\dir1name\\subdir1name\\subdir2name\\subdir3name\\filename.xls"
nap1<-
read.xls(file1,sheet=3,method="tab",perl=perl.path,head=T,row.names=1)}
Erreur dans xls2sep(xls, sheet, verbose = verbose, ..., method = method,
:
Unable to read translated tab file
'C:\DOCUME~1\OLIVIE~1.ETE\LOCALS~1\Temp\RtmpPF2rxf\file6df11649.tab'.
Erreur dans file.exists(tfn) : argument 'file' incorrect
I tried with other xls files, in other folders and on other physical disks,
and it was still the same.
I didn't upgrade manually either Excel nor Perl , and I cannot see tracks of
automatic upgrades.
I had a look at the ChangeLog file in the lib/gdata folder, saw that some
changes were dealing with xls2sep... but couldn't find some help, or at
least couldn't understand it...
Can someone help, and please excuse me if the answer is obvious... maybe I
lack some stronger coffee this morning !
Very best regards to all of you. Olivier
--
Olivier ETERRADOSSI
Maître-Assistant
animateur du groupe Sensomines (Institut Carnot M.I.N.E.S)
-------------------------------------------------------------
CMGD
Pôle "Matériaux Polymères Avancés"
axe "Propriétés Psycho-Sensorielles des Matériaux"
-------------------------------------------------------------
Ecole des Mines d'Alès
Hélioparc, 2 av. P. Angot, F-64053 PAU CEDEX 9
tel std: +33 (0)5.59.30.54.25
tel direct: +33 (0)5.59.30.90.35 fax: +33 (0)5.59.30.63.68
http://www.mines-ales.fr
e-mail : olivier.eterrado...@mines-ales.fr
______________________________________________
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.
______________________________________________
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.
--
Ivan CALANDRA
PhD Student
University of Hamburg
Biozentrum Grindel und Zoologisches Museum
Abt. Säugetiere
Martin-Luther-King-Platz 3
D-20146 Hamburg, GERMANY
+49(0)40 42838 6231
ivan.calan...@uni-hamburg.de
**********
http://www.for771.uni-bonn.de
http://webapp5.rrz.uni-hamburg.de/mammals/eng/mitarbeiter.php
______________________________________________
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.
