similar to: Writing Excel (.xls) files on non-Windows OSs using Perl

A new package called WriteXLS (Version 1.5.0), containing a single function of the same name, is now available via CRAN. The package is made available under the GPL, version >=2. The function is based upon a Perl script that I have previously posted on r-help, now wrapped in R for convenience. It provides a cross- platform function to create Excel 2003 (XLS) files from one or more

A new package called WriteXLS (Version 1.5.0), containing a single function of the same name, is now available via CRAN. The package is made available under the GPL, version >=2. The function is based upon a Perl script that I have previously posted on r-help, now wrapped in R for convenience. It provides a cross- platform function to create Excel 2003 (XLS) files from one or more

The updated package has been submitted to CRAN and has begun to propagate to CRAN mirrors. Package: WriteXLS Version: 1.9.0 Description: Cross-platform perl based R function to create Excel (XLS) files from one or more data frames. Each data frame will be written to a separate named worksheet in the Excel spreadsheet. The worksheet name will be the name of the data frame it contains or can be

The updated package has been submitted to CRAN and has begun to propagate to CRAN mirrors. Package: WriteXLS Version: 1.9.0 Description: Cross-platform perl based R function to create Excel (XLS) files from one or more data frames. Each data frame will be written to a separate named worksheet in the Excel spreadsheet. The worksheet name will be the name of the data frame it contains or can be

I am using read.xls command from the gdata package. I get the following error when I try to read a work sheet from an excel sheet. Error in xls2sep(xls, sheet, verbose = verbose, ..., method = method, : Intermediate file 'C:\Tmp\RtmpYvLnAu\file7f06650f.csv' missing! In addition: Warning message: running command '"C:\Apps\Perl\bin\perl.exe" "C:/Program

Hi Adrian, dat=data.frame(matrix(0,3,3)) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet1",append=F) write.xlsx(dat,"z:/dat.xlsx",sheetName="sheet2",append=F) The above code works and creates new worksheets. But if I want to append to an existing worksheet I seem to get an error.

I?ve got an Excel workbook with about 30 worksheets. Each worksheet has 10000 rows of data over 30 columns. I?d like to read the data from each worksheet into a dataframe or matrix in R for processing. Normally, I use read.csv when interacting with Excel but I?d rather manipulate a multisheet workbook directly than set about splitting the original workbook and saving down each part as a csv.

Dear All, I am using WriteXLS to write tables with multiple sheets with the command: WriteXLS("tables", ExcelFileName = fileName, SheetNames = tableList, perl = "perl", verbose = FALSE, Encoding = c("UTF-8", "latin1"), row.names = TRUE, col.names = TRUE, AdjWidth = TRUE, AutoFilter = FALSE, BoldHeaderRow = FALSE,

Hi, I would like to some excel files with some worksheets. I tried this with the following R script: library(gdata) i<-1 rc<-0 while(rc != "try-error") { wksh<-try(read.xls("cluster-microarray-FW.xls",sheet=i,verbose=TRUE,perl="perl")) rc<-class(wksh) print(sprintf("------- i=%2d rc=%s ---------------",i,rc)) if (rc !=

The updated package has been submitted to CRAN and will propagate to mirrors over the next day or so. It is maintained on R-Forge at http://r-forge.r-project.org/projects/writexls , where downloads are available as well. Package: WriteXLS Version: 1.7.1 Description: Cross-platform perl based R function to create Excel (XLS) files from one or more data frames. Each data frame will be

The updated package has been submitted to CRAN and will propagate to mirrors over the next day or so. It is maintained on R-Forge at http://r-forge.r-project.org/projects/writexls , where downloads are available as well. Package: WriteXLS Version: 1.7.1 Description: Cross-platform perl based R function to create Excel (XLS) files from one or more data frames. Each data frame will be

Jorge was kind enough to point out that I made a mistake in referencing gabor's solution. See below. Thanks Jorge. -------- Begin forwarded message -------- Subject: Re: [R] Writing xls - multiple sheets Date: 3/12/2009 6:03:13 PM From: Jorge Ivan Velez To: markleeds@verizon.net Hi Mark, Yes, he did (as always), but it is not what Ferry needed. Here is Gabor's post:

Hi, If I open up a worksheet in MS Excel 97, the file name is modified by appending an extra .xls to the name. Multiple .xls's are possible, and it is not necessary to save the worksheet. I'm running Wine-20010305 compiled on a SuSE 7.0 running a stock 2.4.2 Linux kernel. MS Excel is being run from an existing Win98 system partition. Thought someone might want to know, Dick --

I can currently append an entire worksheet with write.xls, but would also like to be able to append within the same worksheet. Is this possible? It doesn't seem to work if I use append = T Thanks, Mark -- Mark W. Kimpel MD Neuroinformatics Department of Psychiatry Indiana University School of Medicine

I am having a problem in reading the columns from an xls file. Following is the code: workbook = Spreadsheet::ParseExcel.parse(params[:dump][:file]) worksheet = workbook.worksheet(0) skip=0 worksheet.each(skip) { |row| puts row.at(0) } I am storing "Customer" in the first row first column. When I print, it is received as

The updated package has been submitted to CRAN and will propagate to mirrors over the next day or so. It is maintained on R-Forge at http://r-forge.r-project.org/projects/writexls, where downloads will eventually be available as well. Package: WriteXLS Version: 2.0.1 Description: Cross-platform Perl based R function to create Excel 2003 (XLS) files from one or more data frames. Each data

The updated package has been submitted to CRAN and will propagate to mirrors over the next day or so. It is maintained on R-Forge at http://r-forge.r-project.org/projects/writexls, where downloads will eventually be available as well. Package: WriteXLS Version: 2.0.1 Description: Cross-platform Perl based R function to create Excel 2003 (XLS) files from one or more data frames. Each data

As part of my project to put different types of results into worksheets, I would like to be able to put an auto-generated methods section. If I compose in RWinEdt, read into R, and use write.table with a .txt file extension, what I get out has line-breaks that correspond to those I put in in the first place. If I do the same thing but write.xls with .xls extention, I get an Excel worksheet

R 2.0.0 patched under win2000. MS Office Excel 2003. ODBC Drivers? This may not come as a surprise -- sqlFetch() (and perhaps other ?) appear not to handle table/worksheet names with spaces in them in Excel tables. I was not able to find documentation that specifically mentioned this, although the Help pages vaguely hinted that there might be difficulty with Excel's "peculiar

One can import data from Excel ODBC source, but of course it is user's responsibility to ensure that the data are consistent. Each worksheet in the Excel workbook can be accessed as a table (for example, for Sheet1, you should type "select * from [Sheet1$]". The worksheet should have first row containing the column names, and the data rows should follow (the