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.
