This release is mainly a maintenance release and comes with the following changes:
existsCellStyleto check for existence of cell styles (#71)
getOrCreateCellStylecombinator (#14, #71)
The following example illustrates the use of XLConnect to produce a simple report:
require(XLConnect) # Create new Excel workbook wb <- loadWorkbook("earthquakes.xlsx", create = TRUE) # Create worksheet to hold data targetSheet <- "Earthquakes" createSheet(wb, name = targetSheet) # Export earthquake data writeWorksheet(wb, data = quakes, sheet = targetSheet) # Create cell style to color events with a magnitude >= 6.0 on the # Richter scale largeMagnitudeStyle <- getOrCreateCellStyle(wb, name = "Large Magnitude") # Use solid red foreground to color rows setFillForegroundColor(largeMagnitudeStyle, color = XLC$COLOR.RED) setFillPattern(largeMagnitudeStyle, fill = XLC$FILL.SOLID_FOREGROUND) # Determine large magnitude earthquakes rowIdx <- which(quakes$mag >= 6.0) # Color rows accordingly # NOTE: Since we include a header row in the worksheet # we need to offset the row indices by 1! setCellStyle(wb, sheet = targetSheet, row = rep(rowIdx + 1, each = ncol(quakes)), col = rep_len(seq_len(ncol(quakes)), length(rowIdx)), cellstyle = largeMagnitudeStyle) # Save workbook saveWorkbook(wb)
XLConnect is a comprehensive and cross-platform R package for manipulating Microsoft Excel files from within R. It does not require any installation of Microsoft Excel or any other special drivers to be able to read & write Excel files. The only requirement is a recent version of a Java Runtime Environment (JRE).