similar to: xlsReadWrite v1.5.2

The xlsReadWrite[Pro] packages allow to natively read/write Excel files (.xls) on the Win 32-bit platform. About a week ago new package versions have been released: * xlsReadWrite 1.5.3 is available at CRAN (for R2.11/2.12) and from www.swissr.org/download (binary builds for R2.9 - R2.12) * xlsReadWritePro 1.6.3 is available from www.swissr.org/download (binary builds for R2.9 - R2.12) * (the

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

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.

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

es simple lo unico que tienes que hacer es instalar la libreria(xlsReadWrite) y direccionar y seguidamente especificar el numero de hoja de excel library(xlsReadWrite) dat.excel <- read.xls("d:/ruta del archivo/doc.xls", sheet=1) espero que te sirva ------------------------------------------ El día 18 de agosto de 2010 06:00, <r-help-es-request en r-project.org>

The (*windows only*) xlsReadWrite package has been updated and the new version is available on CRAN. xlsReadWrite natively reads and writes Excel files (v97 - 2003). o Changes from v1.1.1 to v1.3.3 (versions between never really published) - ROWNAMES-support also for matrices (not only for data.frame) - explicit rowNames argument in interface. (stimulated by email Adrian Dusa) -

The xlsReadWrite[Pro] package allows to natively read and write Excel files (.xls) on the Win 32-bit platform. Changes: o fix bug with integer conversion (http://dev.swissr.org/issues/113) PROBLEM: values outside the integer range (i.e. 12345678901) didn't give an NA (and a warning message) but have been converted to a wrong value WHERE: - free/pro: reading an Excel sheet

I am happy to announce that a new version of xlsReadWritePro is available. xlsReadWritePro natively reads and writes Excel files (v97 - 2003) on Windows. The pro version is more powerful than the free version but, beeing a small company, we ask you to support our development and maintenance effort. The following capabilities have been added (compared to xlsReadWrite): ? in-memory objects

Dear UseRs, I have an update ready for the xlsReadWrite package. It runs my unit tests just fine but there are quite a lot of changes and it would be good if some other people could try it out before it will be submited to CRAN. I won't have more time this week, but I hope to publish xlsReadWrite at the end of next week and I will incorporate eventual bugreports and/or (minor) suggestions

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

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]]

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

Hey all, I encountered a problem drawing a histogram. You can view the picture here: http://dl.dropbox.com/u/4836866/Bad_Histogramm.png What happens: the bars are drawn with different starting points, thus no straight zero-line is there. And bars are overlapping. (or sometimes apart from each other.) How it happens: hist(volcano, breaks=10) # and any other data This also happens with

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:

An updated version 1.1.1 of xlsReadWrite has been submitted to cran. Currently the cran version is still 1.0, but you can download the updated version already here: http://treetron.googlepages.com. xlsReadWrite is a package which allows you to natively read and write Excelfiles (windows only). Changes from xlsReadWrite 1.0.0 to 1.1.1 -> added colClasses argument ("rowname",

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:

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

The first version of xlsReadWrite has been uploaded to CRAN. -- WHAT IS IT? / R COMMANDS The package allows you to read and write Excel files natively. The supported Format is BIFF 8, i.e. Excel from version 97 up to 2003. • read.xls( file, colNames = TRUE, sheet = 1, type = "data.frame", from = 1 ) • write.xls( x, file, colNames = TRUE, sheet = 1, from = 1 ) -- PLATFORM / LICENSE