search for: xls

...an access the correct directories, but when he edits or creates a file, the group owner and file permissions are wrong: /home/projects/cp/CP 2007# ls -alt total 2932 drwxrwsrw- 4 daniel cp 4096 2007-11-24 12:35 . -r-------- 1 haffers BUILTIN\users 197120 2007-11-24 12:34 CP 11 Nova.xls -rw-rw-rw- 1 haffers BUILTIN\users 199168 2007-11-23 19:47 CP 10 Octa.xls drwxrwsrwx 2 daniel cp 4096 2007-11-23 19:34 FORMS 2007 -rw-rw-rw- 1 haffers BUILTIN\users 299520 2007-11-23 19:20 2007 ANALYSIS.xls drwxrws--- 26 dnl cp 4096 2007-11-23 15:37 .. -r--------...

Dear all, I have a problem with the function read.xls from the gdata package, error message see below. Two examples: First, I try to read my data, which does not work; Secondly, I tried the example code/data with the Iris data, which worked Any idea? Thanks, Lars > path<-"I:/subProjects/bh/HPGD/" > > setwd(path) > > xls...

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 = sqlFetch(conn, "Sheet1") # read a sheet df = sqlQuery(conn, "select * from [Sheet1 $]&...

Can anyone help me how to read xls file into R. I have tried following library(gdata) xlsfile <- file.path(.path.package('gdata'),'xls','iris.xls') read.xls(xlsfile) I got following error: Converting xls file to csv file... Error in system(cmd, intern = !verbose) : perl not found Error in file.exists(tfn...

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: r...

...opendir . [2005/05/22 02:50:14, 1] smbd/service.c:close_cnum(837) server (192.168.123.20) closed connection to service netlogon And log from backup software: *** Starting Backup Backup Pre-Erase Compressed -- 5/22/2005 - 1:02:58 AM *** F:\Dir\DermaMed Products\Products 2004\Filename-#8-30-04.xls ** The network path was not found. F:\Dir\DermaMed Products\Products 2004\Filename-# 4-30-03.xls ** The network path was not found. F:\Dir\DermaMed Products\Products 2004\Filename-#4-30-03.xls ** The network path was not found. F:\Dir\DermaMed Products\Products 2004\Filename-#1-23-04.xls ** The...

...you want to overwrite, or make new copy" (or some such similar dialog). The file has not changed, and they were the only one with it opened. This happens to everyone, on any Excel file that they open. Here is some smbstatus output when a user opens an Excel spreadsheet: # smbstatus | grep xls 25002 DENY_NONE 0x2019f RDWR NONE /home/shared/projects/Spreadsheet2.xls MonMar 7 11:12:16 2005 Ok, so Samba shows that the user has the file "Spreadsheet2.xls" opened in read-write mode. So far so good. BUT... What is interesting is this: # lsof -p 25002 |grep xls smbd...

R-helpers I have 120 small Excel sheets to read and I am using library(xlsReadWrite): one example below. I had hoped to read sheets by looping over a list of numbers in their name (eg Book1.xls, Book2.xls, etc). I thought I had seen examples which used eval-parse-paste in this way. However, I have not been able to get it to work.. 1. is this a feasible ap...

I’m trying to export a file from R to excel using the xlsReadWritePro function and I keep getting the error below. I get the same error when I use the oledatetime function. My current date format is mm/dd/yyyy, which is how I want it in excel. Also is there anyway to export different datasets to multiple sheets similar to the ods function in SAS? &l...

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 addit...

...t;) R > URL <- "http://people.su.se/" R > PATH <- "~lundh/data/" R > FILE <- "cpi_kpix.rda" R > download.file(paste(URL,PATH,FILE,sep=""), + "cpi_kpix.rda") R > library(gdata) R > FILE <- "Stock_Returns_1931_2002.xls" R > stock.xls <- read.xls(paste(URL, PATH, FILE, sep = ""), + header = TRUE)[, 3:4] Downloading... Done. Converting xls file to csv file... Done. Reading csv file... Done. Im not suppose to download the file though its already on my computer. How do i type in the path s? R...

...till the problem is persisting. Further diagnosing the problem there are double entries of the files in the directory kindly see entries 45-50 & 63-68 find . -uid 11254 -exec ls -l "{}" ";"|nl | more 45 -rwxr--r-- 1 bhavesh.kumar root 27136 Feb 7 15:44 Appraisal-ADP.xls 46 -rwxr--r-- 1 bhavesh.kumar root 24064 Feb 7 15:44 Appraisal-DAL.xls 47 -rwxr--r-- 1 bhavesh.kumar root 26112 Feb 7 15:44 Appraisal-Guidelines.xls 48 -rwxr--r-- 1 bhavesh.kumar root 55296 Feb 7 15:44 Appraisal-GUI.xls 49 -rwxr--r-- 1 bhavesh.kumar root 30208 Feb 7 15:44 Ap...

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 <http://stackoverflow.com/questions/3426523/odbcconnectexcel-function-from-rodbc-package-for-r...

Hi, I encountered a problem of not being able to read in an excel spreadsheet using read.xls() in the xlsReadWrite package. can anyone help? Here is an example code write.xls(matrix(1:9,nrow=3),"ttt.xls") read.xls("ttt.xls") Error in read.xls("ttt.xls") : Unexpected error. Message: Can't find the file "ttt.xls" The "ttt.xls" file...

I can currently append an entire worksheet with write.xls, but would also like to be able to append within the same worksheet. Is this possible? It doesn't seem to work if I use append = T Thanks, Mark -- Mark W. Kimpel MD Neuroinformatics Department of Psychiatry Indiana University School of Medicine

I'm an R newbie and had a question about the read.xls function. I've heard that this is often not a reliable function to use for importing data. However, I have created numerous xls files which contain information about voter turnout and macroeconomic indicators in India. I'm writing a paper on the relationship between economic growth and vote...

...ds > > > Ankush > Further diagnosing the problem there are double entries of the files in the directory kindly see entries 45-50 & 63-68 find . -uid 11254 -exec ls -l "{}" ";"|nl | more 45 -rwxr--r-- 1 bhavesh.kumar root 27136 Feb 7 15:44 Appraisal-ADP.xls 46 -rwxr--r-- 1 bhavesh.kumar root 24064 Feb 7 15:44 Appraisal-DAL.xls 47 -rwxr--r-- 1 bhavesh.kumar root 26112 Feb 7 15:44 Appraisal-Guidelines.xls 48 -rwxr--r-- 1 bhavesh.kumar root 55296 Feb 7 15:44 Appraisal-GUI.xls 49 -rwxr--r-- 1 bhavesh.kumar root 30208 Feb 7 15:4...

Hi, all, I'm trying to use RODBC to read data from Excel. However, I'm having trouble converting missing values to NA and rather perplexed by the output. Below illustrates my problem: ## DATA - copy to Excel and save as "tmp.xls" ## tmp.xls!Sheet1 x 0.11 0.11 na na na 0.11 ## tmp.xls!Sheet2 x 0.11 0.11 na na na na 0.11 ## R Code read.xls <- function(file, sheet = "Sheet1", ...) { require(RODBC) channel <- odbcConnectExcel(file) sheet <- sprintf("select * from `%s$`", sheet) x...

Hi Download the xls file from this link http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls <http://www.nseindia.com/content/fo/fii_stats_12-Oct-2012.xls> I tried this --------------------------------------------------------------- library(XLConnect) url = "http://www.nseindia.com/content/fo/fi...

I have attached a file downloaded from database mirWalk. Apparently it is in XLS format (this is the extension of the downloaded file). However, I cannot open it with OpenOffife spreadsheet program 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...