Olivier ETERRADOSSI
2010-Apr-07 08:46 UTC
[R] behaviour of xls2sep when running read.xls (package gdata) sinceupgrade of R
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' incorrectI 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
Gabor Grothendieck
2010-Apr-07 11:36 UTC
[R] behaviour of xls2sep when running read.xls (package gdata) sinceupgrade of R
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. >