search for: xls2sep

...(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 fo...

...rogram and Excel itself cannot separate the columns as it does when a true XLS file is loaded. I tried to read the attached downloaded file through R function "read.xls" and got the following message > read.xls("Prostatic_Neoplasm-miRNAs.Disease-GenesTargets.xls") Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Unable to read translated csv file '/tmp/RtmpPIe3vo/file15d9580e.csv'. Error in file.exists(tfn) : invalid 'file' argument I have tried reading the file through "read.table" which has now been hanging for more th...

...tates.1252 [4] LC_NUMERIC=C [5] LC_TIME=English_United States.1252 attached base packages: [1] stats graphics grDevices utils datasets methods base other attached packages: [1] gdata_2.12.0 loaded via a namespace (and not attached): [1] gtools_2.7.0 I get the same message from xls2sep("22_data.xls"). It's only a comment, so I suppose I could ignore it. However, it's generated by a function I'm adding to the Ecdat package, and I'd rather find a way to avoid it. (I suppose I could dump it to sink, but that's pretty extreme and could mask...

Hi, I am having problem with the read.xls function. I am trying to read a .xls file but it's giving me error. > read.xls("XXX.xls") Error parsing file 'XXX.xls'. Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file '/tmp/Rtmp5QQjSI/file1665315c.csv' missing! In addition: Warning message: running command '"/usr/bin/perl" "/home/t227/R/x86_64-pc-linux-gnu-library/2.12/gdata/perl/xls2csv.pl" "XXX.xls&...

I am using read.xls command from the gdata package. I get the following error when I try to read a work sheet from an excel sheet. Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file 'C:\Tmp\RtmpYvLnAu\file7f06650f.csv' missing! In addition: Warning message: running command '"C:\Apps\Perl\bin\perl.exe" "C:/Program Files/R/R-2.13.0/library/gdata/perl/xls2csv.pl" "exc...

Hi Using R 2.10.1 on a mac os 10.6.2, I have have a problem with gdata package. When I use the command read.xls, I get this error-message: Erreur dans xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Unable to read translated csv file '/var/folders/gb/gbzQ4sqTF-KK3D5m6v-IJE+++TI/-Tmp-//Rtmp3Hprw9/file10d63af1.csv'. Erreur dans file.exists(tfn) : argument 'file' incorrect dyld: lazy symbol binding failed: Symbol not found...

I've suddenly started seeing a consistent problem with read.xls. No matter what xls file I try I always get an error message of this type: Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file '/var/folders/cb/vvshkpm90lx_y2n69qlyw4z40000gn/T//RtmpK50r4g/file546a2722.csv' missing! In addition: Warning message: running command '"/usr/bin/perl" "/Library/Frameworks/R.framework/Versions/2...

..."C:/Dropbox/R/library/gdata/perl/ xls2csv.pl" "C:/Dropbox/Animals/LARPBO/Database.xlsx" "C:\Users\Robin\AppData\Local\Temp\RtmpWkmGgn\file1bcc2cfe7499.csv" "1" '... Unable to open file 'C:/Dropbox/Animals/LARPBO/Database.xlsx'. 2 Done. Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file 'C:\Users\Robin\AppData\Local\Temp\RtmpWkmGgn\file1bcc2cfe7499.csv' missing! In addition: Warning message: running command '"C:\Perl64\bin\perl.exe" "C:/Dropbox/R/library/gdata/perl/ xls2csv.pl&qu...

...xcel" Lo que creo que es inevitable en Ubuntu <http://stackoverflow.com/questions/3426523/odbcconnectexcel-function-from-rodbc-package-for-r-not-found-on-ubuntu> Con gdata -> Unable to open file '/home/miguelfg/R/x86_64-pc-linux-gnu-library/3.1/gdata/xls/madrid.xls'.Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file '/tmp/RtmpHRuknw/filefed757fcc67.csv' missing!In addition: Warning message:running command ''/usr/bin/perl' Con XLConnect -> Error : package ?rJava? was built before R 3.0.0: please re-install itERR...

...Ubuntu >> <http://stackoverflow.com/questions/3426523/odbcconnectexcel-function-from-rodbc-package-for-r-not-found-on-ubuntu> >> Con gdata -> >> >> >> Unable to open file '/home/miguelfg/R/x86_64-pc-linux-gnu-library/3.1/gdata/xls/madrid.xls'.Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : >> Intermediate file '/tmp/RtmpHRuknw/filefed757fcc67.csv' missing!In addition: Warning message:running command ''/usr/bin/perl' >> >> Con XLConnect -> >> >> >> Error : package ?rJav...

...koverflow.com/questions/3426523/odbcconnectexcel-function-from-rodbc-package-for-r-not-found-on-ubuntu> >>>> Con gdata -> >>>> >>>> >>>> Unable to open file '/home/miguelfg/R/x86_64-pc-linux-gnu-library/3.1/gdata/xls/madrid.xls'.Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : >>>> Intermediate file '/tmp/RtmpHRuknw/filefed757fcc67.csv' missing!In addition: Warning message:running command ''/usr/bin/perl' >>>> >>>> Con XLConnect -> >>>> >&gt...

Hola, Pensé que esto iba a ser trivial en R, pero me estoy encontrado muchos con mi problema en internet, y que las soluciones ofrecidas no terminan de funcionar. Estoy intentando leer un fichero .xls en ubuntu con los siguientes paquetes y nada: require(RODBC) conn = odbcConnectExcel("madrid.xls") # open a connection to the Excel file sqlTables(conn)$TABLE_NAME # show all sheets df =