Displaying 20 results from an estimated 30000 matches similar to: "Weird read.xls behavior"
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 addition: Warning message:
running command
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 was
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:
running command
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 the following
2006 Dec 07
2
How to use read.xls in R
Hello there,
In gdata package, read.xls is to be used for reading excel data (from
windows).
The following is my code:('C:/session/sampledata.xls' is where the file
is stored)
data1<-read.xls('C:/session/sampledata.xls',sheet=1)
and I got the following error message:
Error in system(cmd, intern = !verbose) : perl not found
Could you please tell me what I have done wrong and
2011 May 26
1
Using read.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
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 voter turnout.
This is the command I use:
2011 Jul 07
2
gdata read.xls() values format problem
Dear All,
When I use read.xls() in gdata package to read xls files, I noticed an issue
and couldn't find any solutions after I serched all previous posts.
In the excel file, the number value, for example, is actually 2.3456789 but
formatted as 2.3 (Format Cells ---> Decimal places:1). After I use
read.xls() to import the excel file, I found that, in R, this number is read
as the formatted
2011 Feb 08
1
read.xls counts more rows than I really have in my Excel file
Hi,
i'm using read.xls, and it counts more rows in my Excel than I really have.
i've used both:
especie26 <- read.xls("especie26cargar.xls")
datos26 <- read.xls("especie26cargar.xls", header = TRUE, as.is = FALSE,
na.strings = "NA",
skip = 0, check.names = TRUE, fill = FALSE,
strip.white = FALSE, blank.lines.skip = TRUE)
when i
2012 Jun 13
1
reading xls files using read.xls and xlsReadWrite
Dear R list,
I am trying to read in .xls files. I have tried using package 'gdata', I
get the following error.
> dataset <- read.xls("June.xls")
Wide character in print at
/Library/Frameworks/R.framework/Versions/2.14/Resources/library/gdata/perl/
xls2csv.pl line 262.
Seems like this is a problem coming from Perl?
I tried to install package 'xlsReadWrite', it
2009 Jul 02
2
read.xls: number of sheets
Hi,
I'm trying to read several Excel sheets from an Excel file into a
list. I'm using
read.xls from package 'gdata'. I would like to know how I can
check the number of sheets before the loop (in the example below) so
that I could adjust the loop counter? Any suggestions?
DF.list <- list()
for (i in 1:4) {
DF.list[[i]] <- read.xls("sample_file.xls", sheet=i,
2009 Jun 05
1
question about read.xls
I am woking on Windows and using read.xls to read Excel.xls file.
But it needs to install perl on my machine first, and then give the
following until it can work:
read.xls(file,sheet=i,perl="E:\\Perl\\bin\\bin\\perl.exe");
I am wondering if there is other way to read Excel.xls file without needing
do this?
jlm
[[alternative HTML version deleted]]
2009 Mar 12
1
read.xls and name of worksheet
Hi,
I would like to some excel files with some worksheets. I tried this with
the following R script:
library(gdata)
i<-1
rc<-0
while(rc != "try-error") {
wksh<-try(read.xls("cluster-microarray-FW.xls",sheet=i,verbose=TRUE,perl="perl"))
rc<-class(wksh)
print(sprintf("------- i=%2d rc=%s ---------------",i,rc))
if (rc !=
2009 Aug 20
1
Read and merge a number of .xls files into one dataframe
Hi everybody
I have a large number of Excel speadsheets that I want to merge into one R
dataframe to process. I can read them one by one with read.xls but I really
need a function to read a whole directory at once and merge the columns with
the same name into a single dataframe.
here is what I have thus far (on Mac OS X 10.5.2. for R 2.8.0):
# Define the directory where the data is
2008 Jun 10
2
A curious bug in read.xls
I found a curious bug in read.xls. I don't know if it's reproducible.
It's like this: suppose I do a read.xls in a spreadsheet. A column
begins with a number. Then, any strings below it will be rendered as NA.
If the column begins with a string, then it will be rendered correctly.
Alberto Monteiro
2012 Dec 04
1
error reading xlsm file with read.xls
Dear all,
I cannot reading a .xlsm file using read.xls.
I executed:
read.xls("resultados.xlsm",
colNames = TRUE,
sheet = 1,
type = "data.frame",
from = 1,
rowNames = NA,
colClasses = "character",
checkNames = TRUE,
dateTime = "numeric",
naStrings = NA,
stringsAsFactors = F)
Error:
Call("ReadXls", file, colNames, sheet, type, from, rowNames, :
2010 Apr 07
1
behaviour of xls2sep when running read.xls (package gdata) sinceupgrade of R
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
2011 Jun 03
4
Problem using read.xls - Everything converted to factors
Hallo,
I would like to use to read.xls function from the gdata package to read
data from Microsoft Excel files but I experienced a problem: For example
I used the following code:
testfile<-read.xls("/home/.../wsjecon0603.xls", #file path
header=F,
dec=",",
na.strings="n.a.",
skip=5,
sheet=2,
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) : invalid 'file' argument
Question *1) What is the way
2012 Dec 04
6
leer .xlsm con read.xls
Buenas tardes usuarios de R.
Estoy tratando de leer un archivo excel con read.xls usando la siguiente
sentencia:
read.xls("resultados.xlsm",
colNames = TRUE,
sheet = 1,
type = "data.frame",
from = 1,
rowNames = NA,
colClasses = "character",
checkNames = TRUE,
dateTime = "numeric",
naStrings = NA,
stringsAsFactors = F)
Pero me da el siguiente error:
Error