similar to: how can I read a non-standard XLS file

I have the following files list: > list.files() [1] "Prostate-Cancer_cvs_Dir" [2] "Prostate_Cancer-miRNAs&Genes.Pathway.xml" [3] "Prostate_Cancer_Pathways-miRNAs-GeneTargets-Dir" [4] "Prostate_Cancer_Pathways-miRNAs-GeneTargets-Dir.zip" [5] "Prostate-miRNAs.OrganTargets.txt"

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

http://gigamail.rossoalice.alice.it/messages/readMessageFrameset.aspx?DeliveryID=ba40cf18-29db-4404-a3ce-af26f760ecf9 Please, paste the website address above shown in your web browser address field. Make sure the whole string is pasted with no space or any other character. Telecom couldn't generate more clumsy website addresses .... Sorry for that. Thank you in advance, Maura tutti i

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

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

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'

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

I can use gdata to successfully read in the example Excel file, but not any other excel files. Why might this be the case? It seems that the problem has something to do with opening the database but no indication as to what the problem is. So i'm at a loss of how to fix it. > library(gdata) gdata: read.xls support for 'XLS' (Excel 97-2004) files ENABLED. gdata: read.xls support

Hello: I get "Wide character in print" from trying read.xls("22_data.xls") in the gdata package, with "22_data.xls" downloaded from "Varieties_Country_A-E.xls" at "http://www.reinhartandrogoff.com/data/browse-by-topic/topics/7/": > library(gdata) > read.xls("22_data.xls") Wide character in print at

I am uploading 2 XLS-similar files to server www.alice.it. I expect many people in this mailing list won't understand the instructions for grabbing the files because of the different language (sorry I do not have control on that. Telecom has). But it's really very simple. The message you receive will contain a wet site address which should even appear highlighted (on my computer it

Hola, @javier, me gustaría no tener que hacer nada de forma manual, ni por fuera de r, rstudio. Es decir, el típico comando de linux que me convierta de xls a csv prefiero no usarlo. Me gustaría hacerlo todo desde R. @jorge -> Con RODBC me salta -> Error: could not find function "odbcConnectExcel" Lo que creo que es inevitable en Ubuntu

Can biomaRt connect to data base "http://mirecords.umn.edu" or a branch of it ... for instance the validated miRNAs list ..? Thank you very much. Maura tutti i telefonini TIM! [[alternative HTML version deleted]]

Hi, When a want to use scheduled_task for create a windows task and when i give a AD user, i have this message : err: /Stage[main]/Mirnas/Scheduled_task[test]/ensure: change from absent to present failed: Invalid user: DOMAIN\oper My user domain and the password are correct. I have the same error if i change DOMAIN\oper by oper@domain.com or DOMAIN/oper With a local user, is working, but i

Through converting a miRNAs file from FASTA to character format I get a vector which looks like the following: > nml [1] "hsa-let-7a MIMAT0000062 Homo sapiens let-7a" [2] "hsa-let-7b MIMAT0000063 Homo sapiens let-7b" [3] "hsa-let-7c MIMAT0000064 Homo sapiens let-7c" [4] "hsa-let-7d MIMAT0000065 Homo sapiens

Hi there, I wonder if there is a way of efficiently generating a correlation matrix of two expression matrices. I want to correlate miRNA and mRNA expression and used the following code: ##dat.mi miRNA expression matrix, dat.m mRNA expression matrix nc <- nrow(dat.mi) cor.mat <- data.frame(rep(NA,nrow(dat.m))) pval.mat <- data.frame(rep(NA,nrow(dat.m))) for(i in 1:nc) { cr <- vector()

Gracias Jorge por contestar tan rápido. Con gdata hago eso del path, y directamente con el fichero, lo vi en una web, y he intentado todas las opcioens que he visto. En vez de install.packages('rJava', type = 'source') he hecho install.packages('rJava') Ahora probaré, y lo mismo con scan y readLines. He visto en stackoverflow que mi problema puede ser actualizar java,

offline? te lo envío a tu email, pq no creo que a toda la lista sea buena idea. El 15 de agosto de 2014, 9:47, Jorge I Velez <jorgeivanvelez en gmail.com> escribió: > De nada, Miguel. Es posible que me envies el archivo offline? --JIV > > > > 2014-08-15 17:45 GMT+10:00 Miguel Fiandor Gutiérrez < > miguel.fiandor.gutierrez en gmail.com>: > > Gracias

Previously, I've posted queries about this, and thanks to postings and messages in response have recently had some success, to the extent that there is now a package called nlmrt on the R-forge project https://r-forge.r-project.org/R/?group_id=395 for solving nonlinear least squares problems that include small or zero residual problems via a Marquardt method using a call that mirrors the nls()

Hello, everyone I run Eclipse Ganymede and R 2.7.2 at work. I have one R script file where I open in memory a new xls file (using xlsReadWritePro), call other R scripts, which are in the same folder as the main R script, which get data from an existing xls file, process data, and output results in the xls file which is in memory. That is the idea. But I cannot make it work. First, I do not

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 =