XLConnect 0.2-14

January 24, 2018

(This article was first published on Mirai Solutions, and kindly contributed to R-bloggers)

CRAN_Status_Badge Research software impact Rdoc

We are pleased to announce the release of XLConnect 0.2-14, now available from CRAN and from our GitHub repository.

This release is mainly a maintenance release and comes with the following changes:

The following example illustrates the use of XLConnect to produce a simple report:


# 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

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

To leave a comment for the author, please follow the link and comment on their blog: Mirai Solutions.

R-bloggers.com offers daily e-mail updates about R news and tutorials on topics such as: Data science, Big Data, R jobs, visualization (ggplot2, Boxplots, maps, animation), programming (RStudio, Sweave, LaTeX, SQL, Eclipse, git, hadoop, Web Scraping) statistics (regression, PCA, time series, trading) and more...

If you got this far, why not subscribe for updates from the site? Choose your flavor: e-mail, twitter, RSS, or facebook...

Comments are closed.

Search R-bloggers


Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)