similar to: R as.numeric()

Dear group, I am working on a rather big project where the output data frames have dimensions of 3000 x 15 or greater. We are using xlsx and xlsx2 to write the data.frames to Excel sheets. Since recently we get the following error, when trying to write the data frames to the excel sheets: Error in ls(envir = envir, all.names = private) : invalid 'envir' argument We figured out that

Dear Rxperts, Through Windows OS, I created shortcuts (paste as shortcut) to excel spreadsheets ( with "xlsx" as the file extension). I wasn't able to read the shortcuts through R and using "read" functions of "xlsx" package. exf <- "a1.xlsx.lnk" > read.xlsx(exf,1) Error in .jcall("RJavaTools", "Ljava/lang/Object;",

All - How can I read in a column of alphanumeric values without including ".0" on the numeric values? Original column: TeamLeaderID 258 342 316 U8 331 279 D1 116 235 296 ... [truncated] leaders = read.xlsx2('FILE', sheetIndex = 1, header = T) Column after it's been read in: leaders$TeamLeaderID 258.0 342.0 316.0 U8 331.0 279.0 D1 116.0 235.0 296.0 ... [truncated] If I

Hola. En un cierto directorio tengo archivos excel y de otros tipos. Cada uno de ellos corresponde a una encuesta a una empresa X. Me gustaria importar los datos de ciertas celdas de ciertas hojas de todos los archivos excel en una sola pasada. ¿Hay alguna forma de hacerlo? Yo se que la variable Z está siempre en la celda X de la hora tanto. Me gustaría ingresarlo todo en una matriz en que

The parameters 'force create mode' and 'force directory mode' have no effect when the option 'unix extensions' is active. The documentation does not report any interaction between the unix extensions and the forced modes, so I'm assuming it's a bug.I'd like to know if it is a known bug ?Has it been solved, if so in which version ? My server runs Debian lenny,

Hi I have a script which is designed to gather data from individual columns from a file, which is an output from an instrument. the file has multiple sections and each a section has data under each column (vars), I am using the name of the column as a variable to gather the column ID using vidx<-grep(vars[vi],gsub("[[:punct:]]","",strrl1[[datbeg-1]]),ignore.case=T) the