search for: xls

Displaying 20 results from an estimated 1183 matches for "xls".

Did you mean: tls
2007 Nov 24
1
Strange file permissions
...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--------...
2009 Aug 18
2
(no subject)
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...
2014 Aug 14
3
leer ficheros excel en R en Ubuntu
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 $]&...
2010 Jun 16
2
Reading data from xls..........please help
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...
2011 Sep 06
1
read.xls (gdata) problem
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...
2005 May 23
1
Odd Disconnect problem, again. (Recv failure for 4?)
...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...
2005 Mar 10
2
Strange issues with Excel & Samba
...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...
2008 Feb 26
3
using eval-parse-paste in a loop
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...
2009 Jul 02
1
help exporting to excel via xlsReadWritePro
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...
2011 Mar 14
1
read.xls can't read some .xls files
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...
2009 Oct 29
3
Trouble retrieving data (.xls) from folder on my computer.
...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...
2008 Feb 19
1
discrepancy between what quota reports and what du reports (second time post)
...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...
2014 Aug 15
5
leer ficheros excel en R en Ubuntu
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...
2010 Apr 02
1
can't read excel file with read.xls()
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...
2007 Feb 09
1
append within worksheet in write.xls
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
2009 Mar 15
3
read.xls question
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...
2008 Feb 08
0
Re: discrepancy between what quota reports and what du reports
...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...
2006 Jul 12
1
RODBC, missing values, and Excel
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...
2012 Oct 15
2
Download a file from url
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...
2010 May 25
2
how can I read a non-standard XLS file
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...