Displaying 20 results from an estimated 1000 matches similar to: "Importing xls from a http://"
2010 Dec 08
3
ReadWrite.xls problem
Dear community,
I have now taken my R-file from lectures and intend to use it at home, but
have a problem
reading the Data from the file. I have installed and loaded the Package
xlsReadWrite so far.
I have also "Changed directory".
This is what I have entered
daten=read.xls("Daten A2")
This is my Error-Message in its German original:
Fehler in .Call("ReadXls",
2011 Aug 24
3
Importing data from MS EXCEL (.xls) to R XXXX
Hello everyone,
What is the simplest, most RELIABLE way to import data from MS EXCEL (.xls)
format to R? In the past I have used the read.xls() function from the
xlsReadWrite package, however, I have been wrestling with it all afternoon
long with no success. I continue to receive the following error message:
> {widge<-read.xls("F:\\Classes\\Z1.Data\\stat.3010\\WidgeOne.xls",
+
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, :
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
2012 Mar 15
2
Importing multiple worksheets from one Excle/ csv file into R
Dear R experts,
I am trying to import some data from some Excle files into R. My Excle file
contains about 50 sheets.
One solution I can think about is to convert my Excle file into csv file
first and then load data into R using 'read.csv'.
But it seems to me that 'read.csv' only supports reading one sheet (or 'one
file') each time, so that seems I have to create 50 csv
2011 Oct 11
5
help to ... import the data from Excel
Hi every one ,,,,
i have problem in R program to import the data from excel ,
I have done the following:
1. install.packages("xlsReadWrite")
2. library(xlsReadWrite)
3. z<- read.xls("ReadXls",LTS,colNames=FALSE,sheet,type,form,rowNames=FALSE)
and i got on the result:
Error in read.xls("ReadXls", LTS, colNames = FALSE, rowNames = FALSE) :
object
2010 Feb 23
1
Importing Headers from excel files
Hello I am trying to import an Excel file but I am loosing the headers, My
headers are in the first to rows of the EXCEL file. In the following R
output, the NA are supposed to be the second item in the Header. Is there
any way to Import more than one row as headers?. Thank you
Felipe Parra
> Data<-odbcConnectExcel('Curva LIBOR.xlsx',readOnly=T,)
>
2006 Apr 25
1
protection needed?
Dear list,
I am unsure if I really need to protect a coerced object if I
immediately access its value and don't access the object anymore. I
tried to find out by looking into the R sources but didn't find
something similar.
It's about the variable _skipLines in the call "function ReadXls(
_file, _sheet, _type, _header, _colHeader, _skipLines: pSExp ): pSExp;
cdecl;".
I
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
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 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 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 Apr 21
3
R CMD Sweave versus Sweave() on Windows
Dear list subscriber,
I am quite puzzled by the behaviour of processing Sweave files within an R session, i.e.
Sweave("foo.Rnw") versus R CMD Sweave foo.Rnw
In the former the environmental variable 'SWEAVE_STYLEPATH_DEFAULT = TRUE' is obeyed (this is set in etc/Renviron.site as well as under the users home directory in .Renviron). That is the hard-coded path to Sweave.sty is
2011 Dec 04
3
RODBC connect to Excel (64-bit Windows 7)
Hi to all.
I have a problem to connect to an Excel database using RODBC.
Namely, I am using 64-bit R 2.14.0, under Windows 7 and I tried following:
library(RODBC)
> channel <- odbcConnectExcel("results.xlsx")
Error in odbcConnectExcel("results.xlsx") :
odbcConnectExcel is only usable with 32-bit Windows # ok this is
clear why it doesn't work
> channel
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
2009 Jan 30
1
Methods not loaded in R-Devel vs 2.8.1
Dear list-member,
I am currently developing a package with S4 classes. The NAMESPACE and DESCRIPTION is printed below. Within this package I have set a method "residuals" for two classes. In version 2.8.1 these two are reported whereas in R-Devel (2009-01-28 r47766). What have I missed? What has changed and how can I rectify the issue? Your help and pointers are welcome.
For 2.8.1:
2009 Nov 16
3
Error on reading an excel file
Hello everybody, here is the code I use to read an excel file containing two
rows, one of date, the other of prices:
library(RODBC)
z <- odbcConnectExcel("SPX_HistoricalData.xls")
datas <- sqlFetch(z,"Sheet1")
close(z)
It works pretty well but the only thing is that the datas stop at row 7530
and I don?t know why datas is a data frame that contains 7531 rows with the
2006 Apr 25
7
R 2.3.0: Use of NULL as an environment is deprecated
Dear R-Devel subscriber,
first, let me express my thank to the R-Core team for the new release! I
appreciate their efforts and time spent to enhance R.
In accordance with the 'NEWS' file (see excerpt of it below),
[...
o Changed the environment tree to be rooted in an empty
environment, available as emptyenv(). baseenv() has been
modified to return an environment with emptyenv() as
2006 Apr 25
7
R 2.3.0: Use of NULL as an environment is deprecated
Dear R-Devel subscriber,
first, let me express my thank to the R-Core team for the new release! I
appreciate their efforts and time spent to enhance R.
In accordance with the 'NEWS' file (see excerpt of it below),
[...
o Changed the environment tree to be rooted in an empty
environment, available as emptyenv(). baseenv() has been
modified to return an environment with emptyenv() as
2008 Jul 24
3
how to export ".xls" file with colorful cells?
Hi all:
I wanna know how to expoort ".xls" file. And in the exported ".xls" file, how to set different cells with different color?
Thanks a lot!
My best.
------------------------------
*******************************************
Xin Meng
Capitalbio Corporation
National Engineering Research Center
for Beijing Biochip Technology
BioPharma-informatics & Software