[R] behaviour of xls2sep when running read.xls (package gdata) sinceupgrade of R

[Gabor Grothendieck]

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.eterradossi at 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.eterradossi at mines-ales.fr
>
> ______________________________________________
> R-help at 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.
>