search for: xlsreadwritepro

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:names...

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! http://thirdpartyoffers.netzero.net/TGL2241/fc/BLSrjpYTn25sHSvcJxIFkg2LQZq3YvMQZNiqayXOtvmGy...

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

...UTION: - an error will be raised for too large/small values (same as in read.table) - numeric data.frame column types default to 'double' (as in the free version) o adapt RUnit tests to new behaviour o some small cosmetic changes Credits to Gyorgy Ottucsak who found the problem in xlsReadWritePro and send us a report (incl. testfile). Thanks a lot! The new xlsReadWrite version will be submitted to CRAN in a moment. Both updated packages are available now from www.swissr.org/download or - full listing - here: http://dl.dropbox.com/u/2602516/swissrpkg/index.html. Cheers, Hans-Peter

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 full download listing is here: http://dl.dropbox.com/u/2602516/swissrpkg/index.html) ###### Changes in xlsReadWrite 1.5.3 (0b78c1) ###### - *important*: fix AV when reading large data (issue #110: in a subro...

Hello, everyone I run Eclipse Ganymede and R 2.7.2 at work. I have one R script file where I open in memory a new xls file (using xlsReadWritePro), call other R scripts, which are in the same folder as the main R script, which get data from an existing xls file, process data, and output results in the xls file which is in memory. That is the idea. But I cannot make it work. First, I do not really know how to call other R scripts from an R s...

Hi, Is there a package I can use to write to multiple sheets on xls file, other than using the paid version of xlsReadWrite package (xlsReadWritePro)? Thank you, Ferry

...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 data, output, and methods. That, in fact, is why I bought the Pro version of xlsReadWritePro. I have been saving graphics as PDF files, then inserting them as object in Excel sheets. What I would like to be able to do is to embed objects (files) in sheets of a workbook directly from within R. I would also like to be able to save my current R workspace as an object embedded in a sheet s...

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

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 - for detailed documentation pls. download and see: help files, DESCRIPTION and README. - I set up a newsgroup for technical questi...

...ay ( or atleast something related ) so check the archives for his solution. <mailto:markleeds@verizon.net> On Thu, Mar 12, 2009 at  4:29 PM, Ferry wrote: Hi, Is there a package I can use to write to multiple sheets on xls file, other than using the paid version of xlsReadWrite package (xlsReadWritePro)? Thank you, Ferry ______________________________________________ R-help@r-project.org <mailto:R-help@r-project.org> mailing list https://stat.ethz.ch/mailman/listinfo/r-help <https://stat.ethz.ch/mailman/listinfo/r-help> PLEASE do read the posting guide http://www.R-project.org/po...

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 friends. Every loop of my program will result in a list that is very long, with a structure similar to the one below: Lst <- list(name="Fred", wife="Mary", daily.incomes=c(1:850)) Please notice the large size of "daily.incomes". I need to store all such lists in a csv file so that I can easily view them in Excel. Excel cannot display a row of more than 300

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

#Hi R-users, #Suppose that I have a data.frame like this: y1 <- rnorm(10) + 6.8 y2 <- rnorm(10) + (1:10*1.7 + 1) y3 <- rnorm(10) + (1:10*6.7 + 3.7) y <- c(y1,y2,y3) x <- rep(1:3,10) f <- gl(2,15, labels=paste("lev", 1:2, sep="")) g <- seq(as.Date("2000/1/1"), by="day", length=30) DF <- data.frame(x=x,y=y, f=f, g=g) DF$g[DF$x == 1]