similar to: ReadWrite.xls problem

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

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", +

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

Does anyone have a work-around for a failed installation of this package? > library(xlsReadWrite) xlsReadWrite version (cran shlib) Copyright (C) 2010 Hans-Peter Suter, Treetron, Switzerland. !! Your installation contains the cran placeholder shlib (dll/so). Please get the regular shlib (420 KB) by executing the following command: xls.getshlib() However, the xls.getshlib() command fails

Both packages are listed on the website, but neither installs here: gnumeric: ... Cannot find xml2-config ERROR: configuration failed for package ?XML? * Removing ?/usr/local/lib/R/site-library/XML? * Installing *source* package ?gnumeric? ... ** R ** preparing package for lazy loading Warning in library(pkg, character.only = TRUE, logical.return = TRUE, lib.loc = lib.loc) : there is no package

A naive question: what happened to the xlsReadWrite package? http://cran.r-project.org/web/packages/xlsReadWrite/ It says that it was removed from the CRAN repository. Are there any plans for it be available again? Thanks, Andrew [[alternative HTML version deleted]]

Hi useRs, I would like to know what R users are employing to get their images/plots created in R, into Excel sheets. I am aware of the various packages (xlsReadWrite, RODBC) to get data frames into R, but I would like to copy images too. Thank you for any help in solving this problem. Regards, Harsh Singhal

Dear all, i use the following package/syntax to export data to excel: library(xlsReadWrite) write.xls( exportdata,pfad,colNames = TRUE,sheet = 1,from = 1,rowNames = FALSE ) Everything is fine, but the format of the export is not the best. For example, I every time have to adjust the column width. Furthermore there is no possibility to highlight some cell or make them colourful. I create a lot

Dear all, I installed xlsReadWrite package under Windows 7, and got error when trying to run xls.getshlib(). Please, see the errors below: > require(xlsReadWrite) Loading required package: xlsReadWrite xlsReadWrite version (cran shlib) Copyright (C) 2010 Hans-Peter Suter, Treetron, Switzerland. !! Your installation contains the cran placeholder shlib (dll/so). Please get the regular shlib

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

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, :

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

Hello! After performing an analysis with betadisper, package vegan I would like to plot the results - so far, so good. But I would also like to "tune" a little bit the plotting characters, as '+' and 'x' are a little to similar... My (boiled down) code: [See session info at the bottom of the mail, vegan is vegan_2.0-3] mod <- betadisper(mydata, mygroups,

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

Hi, if i have data in the following time series format: time, amount, state 1 2222 A 1 333 B 2 45 A 2 77 B where states could be n and time periods t is there a package in R that would calculate the transition probabilities in a markov chain. for each t except t=0 to generate A B A B perhaps the best structure might

Hi friends, I have installed R 2.4.0 in my pc. I have a file xls entitled dali following this directory:c://programfiles//R 2.4.0. Recently I have installed xlsreadwrite 1.3.2. but , when I wrote the following lines: >library(xlsReadWrite) >read.xls( file, colNames = TRUE, sheet = 1, type = "data.frame", from = 1, colClasses = NA ) I obtained from R console the following messages:

Hi, i'm trying to read some data from excel files but it seems that neither xlsReadWrite nor sqlFetch (RODBC) doesn't like the format (Excel 5.0). When i open the file in Excel and save it in a new format Excel 97 -2003 everything works fine. Is it possible to use ODBC connection to open old format files, or i guess i will have to open and save every file in Excel in new format, which

Dear all,   I was using older version of R (installed early). I install new version of R (R.2.9.0) but i could not find package "xlsReadWrite" to read Excel file. Is there any alternatives to read Excel file ? I hope it should be. I need help although it is minor querry. Thanks in advance.   Sincerely, Ram Kumar Basnet Wageningen University, The Netherlands   [[alternative HTML

Hi, I'm trying to install R on Ubuntu. I succeeded at installing the r-recommended package that is present in the synaptics, but i can't find the xlsReadWrite package in the repositories included in my synaptics manager. Does anybody know a liable repository in which this package is present. Thanks in advance -- View this message in context:

Argh, just now I saw a scrambled start-up message when running xlsReadWrite1.5.2 in R2.12.0 (32-bit) on a Win7 64-bit platform. If you have this situation and use xlsReadWrite 1.5.2 (probably all earlier versions also) you can download a quick fix, see below. I don't know if this also affects Vista/XP 64 bit. - Probably on the weekend I'll have time to release a proper new 1.5.3 version.