search for: readxl

Displaying 20 results from an estimated 38 matches for "readxl".

Did you mean: readl
2010 Dec 08
3
ReadWrite.xls problem
...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", file, colNames, sheet, type, from, rowNames, : Falsche Anzahl von Argumenten (11), erwarte 10 f?r ReadXls This is my Error-Message in its english translation: Error in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : Wrong Number of Arguments (11), expect 1...
2017 Nov 17
3
Dataframe is character
Hi everybody, Question: why are my dataframe and numeric variables a character? I read an excel file via readxl but my dataframe is a character, and numeric variables, eg "yi", are also a character. My excelfile is in English numeric Sometimes the dataframe was indeed a dataframe, but I do not know why it did sometimes. Thank you in advance, Roberto PS I used "guess". The problem is not s...
2012 Mar 15
2
Importing multiple worksheets from one Excle/ csv file into R
...example (e.g. 3 sheets in one Excle file, saved at 'Z:/WORK_2012/Data/' on my PC and is called 'test.xls' ) But my code failed to work. ----------------- library(xlsReadWrite) data1<-read.xls("Z:/WORK_2012/Data/test.xls") Error in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : Incorrect number of arguments (11), expecting 10 for 'ReadXls' ------------------ By reading the error message I thought the error message trys to tell me that I need to set some arguments, so I found all the arguments from http:...
2017 Nov 17
0
Dataframe is character
class("dat") is different from class(dat), which is what you actually want. On 17-11-17, P. Roberto Bakker wrote: > Hi everybody, > > Question: why are my dataframe and numeric variables a character? > > I read an excel file via readxl but my dataframe is a character, and > numeric variables, eg "yi", are also a character. > My excelfile is in English numeric > Sometimes the dataframe was indeed a dataframe, but I do not know why it > did sometimes. > Thank you in advance, Roberto > PS I used "gue...
2012 Dec 04
1
error reading xlsm file with read.xls
...ile 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, : Incorrect number of arguments (11), expecting 10 for 'ReadXls' If I just write read.xls("resultados.xlsm") It give me the same error. Regards, Sebastián. [[alternative HTML version deleted]]
2011 Jan 25
1
Importing xls from a http://
I know a lot of people asked similar questions like this. I have tried using read.xls () Error in .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : Incorrect number of arguments (11), expecting 10 for ReadXls read.table or read.csv (Wrong table format) odbcConnectExcel have problem with the URL I want to import this excel file (http://www.econ.yale.edu/~shiller/data...
2017 Jul 30
0
How export data set (available in the package) from R?
I also suggest you Hadley's optimized package for interoperating xls files with R: https://github.com/tidyverse/readxl https://cran.r-project.org/web/packages/readxl/index.html
2017 Sep 20
2
Keep on getting message errors when trying to install and load packages
...\Documents\R\win-library\3.4\haven? package ?readstata13? successfully unpacked and MD5 sums checked Warning: unable to move temporary installation ?C:\Users\PaulBernal\Documents\R\win-library\3.4\file2f741507f27\readstata13? to ?C:\Users\PaulBernal\Documents\R\win-library\3.4\readstata13? package ?readxl? successfully unpacked and MD5 sums checked Warning: unable to move temporary installation ?C:\Users\PaulBernal\Documents\R\win-library\3.4\file2f74271b1a7a\readxl? to ?C:\Users\PaulBernal\Documents\R\win-library\3.4\readxl? package ?RcmdrMisc? successfully unpacked and MD5 sums checked Warning: un...
2012 Dec 04
6
leer .xlsm con read.xls
...ead.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 en .Call("ReadXls", file, colNames, sheet, type, from, rowNames, : Incorrect number of arguments (11), expecting 10 for ''ReadXls'' Si utilizo directamente: read.xls("resultados.xlsm") Me da el mismo error. ¿Cuál será el problema? Saludos, Sebastián. [[alternative HTML vers...
2017 Jul 30
5
How export data set (available in the package) from R?
"Data set flchain available in the survival? package". ?How can?I get?it (from R)? as Excel file? Thanks! [[alternative HTML version deleted]]
2017 Sep 21
0
Keep on getting message errors when trying to install and load packages
...3.4\haven? > package ?readstata13? successfully unpacked and MD5 sums checked > Warning: unable to move temporary installation > ?C:\Users\PaulBernal\Documents\R\win-library\3.4\file2f741507f27\readstata13? > to ?C:\Users\PaulBernal\Documents\R\win-library\3.4\readstata13? > package ?readxl? successfully unpacked and MD5 sums checked > Warning: unable to move temporary installation > ?C:\Users\PaulBernal\Documents\R\win-library\3.4\file2f74271b1a7a\readxl? > to ?C:\Users\PaulBernal\Documents\R\win-library\3.4\readxl? > package ?RcmdrMisc? successfully unpacked and MD5 sums...
2017 Sep 21
2
Keep on getting message errors when trying to install and load packages
...eadstata13? successfully unpacked and MD5 sums checked > > Warning: unable to move temporary installation > > ?C:\Users\PaulBernal\Documents\R\win-library\3.4\ > file2f741507f27\readstata13? > > to ?C:\Users\PaulBernal\Documents\R\win-library\3.4\readstata13? > > package ?readxl? successfully unpacked and MD5 sums checked > > Warning: unable to move temporary installation > > ?C:\Users\PaulBernal\Documents\R\win-library\3.4\ > file2f74271b1a7a\readxl? > > to ?C:\Users\PaulBernal\Documents\R\win-library\3.4\readxl? > > package ?RcmdrMisc? successf...
2017 Sep 21
0
Keep on getting message errors when trying to install and load packages
...ully unpacked and MD5 sums checked >> > Warning: unable to move temporary installation >> > ?C:\Users\PaulBernal\Documents\R\win-library\3.4\file2f74150 >> 7f27\readstata13? >> > to ?C:\Users\PaulBernal\Documents\R\win-library\3.4\readstata13? >> > package ?readxl? successfully unpacked and MD5 sums checked >> > Warning: unable to move temporary installation >> > ?C:\Users\PaulBernal\Documents\R\win-library\3.4\file2f74271 >> b1a7a\readxl? >> > to ?C:\Users\PaulBernal\Documents\R\win-library\3.4\readxl? >> > package...
2017 Sep 21
1
Keep on getting message errors when trying to install and load packages
...ms checked >>> > Warning: unable to move temporary installation >>> > >>> > ?C:\Users\PaulBernal\Documents\R\win-library\3.4\file2f741507f27\readstata13? >>> > to ?C:\Users\PaulBernal\Documents\R\win-library\3.4\readstata13? >>> > package ?readxl? successfully unpacked and MD5 sums checked >>> > Warning: unable to move temporary installation >>> > >>> > ?C:\Users\PaulBernal\Documents\R\win-library\3.4\file2f74271b1a7a\readxl? >>> > to ?C:\Users\PaulBernal\Documents\R\win-library\3.4\readxl? &g...
2017 Aug 14
4
tidyverse repeating error: "object 'rlang_mut_env_parent' not found"
...output from dplyr::group_by() 2) Using tibble::tibble() with <name> = <value> arguments 3) Using dplyr::select() on a tibble to select two columns Any obvious clues as to what's happening here? The only non-base packages loaded are current tidyverse, forcats, magrittr, readxl and stringr. Thanks, John John Szumiloski, Ph.D. Principal Scientist, Statistician Pharmaceutical Development / Drug Product Science & Technology NBR105-1-1411 Bristol-Myers Squibb P.O. Box 191 1 Squibb Drive New Brunswick, NJ 08903-0191 (732) 227-7167 ________________________________...
2017 Aug 18
2
R Issues with packages
...try installing all dependencies using this code install.packages(c("devtools","rstudioapi","shiny","miniUI","data.table","stringr","DT","XML","httr","tcltk","RCurl","Hmisc","readxl","RSelenium"), dependencies=TRUE, repos=c("http://rstudio.org/_packages", "http://cran.rstudio.com")) That returns this Warning in install.packages : package ?tcltk? is not available (for R version 3.3.3) Warning in install.packages : pac...
2020 Oct 23
1
openxlsx::read.xlsx can't read data without a header
Hi, I try to read 6 rows (from 5th to 10th) from Excel, but I can always get 5. The first row of the 6 becomes the header. How can I add something like "header = FALSE" in the formula, so that the resulting data would be all the 6 rows? A similar problem occurs in readxl::read_xlsx. Thank you! > temp <- openxlsx::read.xlsx(fl_trilem_sgko, sheet="Korea", rows=5:10, cols=25, skipEmptyRows = FALSE, na.strings = "NA") > temp 0.12101775061124695 1 0.09613981 2 0.16259886 3 0.07914472 4 0....
2017 Dec 11
1
file creating
I am using R(3.4.3), Win 7(extreme edition) 32 bit, I have 10 excel files data1,xls, data2.xls .. till data10.xls. I want to create 10 dataframes . How to do ? regards Parth [[alternative HTML version deleted]]
2017 Jun 29
2
Change Rcode for a meta-analysis(netmeta) to use a random effects model instead of a mixed effects model
...after 5 treatment modalities of a distal radius fracture. I have a code to compare the complication and reoperation rates. Currently it is using a mixed effects model. Is it possible to change the code so a random effects model is used? Thank you very much, Jay R code library(meta) library(readxl) All <- read_excel("Basics excel file complication and reoperation rate.xlsx", sheet=1) names(All) <- c("Study_ID","Event_Type","Treatment","Events_n","N","nN") All$Treatment <- factor(All$Treatment, levels=c("PC&qu...
2017 Aug 17
2
How to install Tidyverse on Ubuntu 17.04? Getting gcc errors for -fstack-protector-strong and -Wdate-time
...stalling the dependencies ?colorspace?, ?munsell?, ?plyr?, ?psych?, ?reshape2?, ?bindrcpp?, ?Rcpp?, ?digest?, ?scales?, ?curl?, ?openssl?, ?cellranger?, ?stringi?, ?selectr?, ?tidyselect?, ?broom?, ?dplyr?, ?forcats?, ?ggplot2?, ?haven?, ?httr?, ?jsonlite?, ?lubridate?, ?modelr?, ?purrr?, ?readr?, ?readxl?, ?stringr?, ?tibble?, ?rvest?, ?tidyr?, ?xml2? trying URL 'https://cran.rstudio.com/src/contrib/colorspace_1.3-2.tar.gz' Content type 'application/x-gzip' length 293433 bytes (286 KB) ================================================== downloaded 286 KB try...