similar to: [ANN:] new package xlsReadWrite*Pro*: announce + update.

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

Hi, I just finished xlsReadWritePro, a package that is - like the free xlsReadWrite - capable to read and write native Excel files. The Pro version is a shareware package and adds features such as: ? Sheet handling (select/insert/copy/delete/ren.) ? Select regions (columns, rows, cells or area) ? Append data (several possibilities) ? Work with multiple files at the same time ? Inside information

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

I’m trying to export a file from R to excel using the xlsReadWritePro function and I keep getting the error below. I get the same error when I use the oledatetime function. My current date format is mm/dd/yyyy, which is how I want it in excel. Also is there anyway to export different datasets to multiple sheets similar to the ods function in SAS? <?xml:namespace prefix = o ns =

Dear list members I am pleased to annonce that I have just finished a native Excel reader/writer. It's wrapped up in two packages: either "xlsReadWrite" (open source) or the slightly beefed-up "xlsReadWritePro" (shareware). Working with Excel data is now as easy as writing read.xls and write.xls. Some more details: - Infos and download: http://treetron.googlepages.com -

Hans-Peter and other R developers, How are you? Have you made any progess with embedding Url's in Excel? Well, I have been busy thinking of more things for you to do;) My colleagues in the lab are not R literate, and some are barely computer literate, so I give them everything in Excel workbooks. I have gradually evolved a system such that these workbooks have become compendia of my

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

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

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

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

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

Natively read and write Excel (.xls) files. Supports Windows 32-bit only (atm). A new version has been released: -- changes -- o read.xls - new arguments 'checkNames' - recognize NA values according to a new 'naStrings' argument - recognize NaN values - recognize 'true', 'false' (not case-sensitive) as logical when determing a class for data.frame column;

Natively read and write Excel (.xls) files. Supports Windows 32-bit only (atm). A new version has been released: -- changes -- o read.xls - new arguments 'checkNames' - recognize NA values according to a new 'naStrings' argument - recognize NaN values - recognize 'true', 'false' (not case-sensitive) as logical when determing a class for data.frame column;

Dear all, I often use dates and times in analyses. I just can't figure out how to format my date or time column in R. So, apparently R sees the date as something other than date (character). Let's say I am opening a CSV file, one of the columns of which is a date or time. How do I specify that when opening the file? Thanks for the help, Jim --

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

Is there a way to export multiple datasets into multiple excel spreadsheets using xlsReadWritePro or with xlsReadWrite? Chris Anderson 707.315.8486 www.sassydeals4u.com ____________________________________________________________ Turn any room into a work of art. Click now for beautiful oriental rugs!

Any idea why this library was removed and where could I find it for Windows (only Unix in the Archive) ? Much thanks in advance. Pascal [[alternative HTML version deleted]]

Hello, I have got the following problem: > setwd("C:/temp") > library(xlsReadWrite) > MyData <- read.xls(file="Mappe1.xls", colNames = TRUE,dateTimeAs = "isodatetime") > attach(MyData) > MyData name value times 1 A1 2 2006-05-12 2 A2 3 2006-05-16 3 A3 1 2006-05-12 4 A4 4 2006-05-12 5 A5 2

Hi R users, I am using xlsReadWrite to read a particular excel file. In one of the columns I have dates ( say col=5). Now date column is read by default as numeric. So I used dateTimeAs= "isodatetime". This enables reading in the date format. However in the earlier column (say col=1) I have data which however starts from row 10. So to read data from column one I use