XLConnect-package {XLConnect} | R Documentation |
Manipulate Excel files from R
Package: | XLConnect |
Type: | Package |
Version: | 0.2-7 |
Date: | 2014-01-03 |
URL: | http://www.mirai-solutions.com |
http://miraisolutions.wordpress.com | |
SystemRequirements: | java (>= 6.0) |
Depends: | R (>= 2.10.0) |
Imports: | methods, rJava, utils |
Suggests: | RUnit, lattice, ggplot2 (>= 0.9.3), fImport, forecast, zoo, scales |
License: | GPL-3 |
LazyLoad: | yes |
For an overview over the package please refer to the available demos:
demo(package = "XLConnect")
Mirai Solutions GmbH, xlconnect@mirai-solutions.com
Mirai Solutions GmbH: http://www.mirai-solutions.com
Mirai Solutions Blog: http://miraisolutions.wordpress.com
Apache POI: http://poi.apache.org
# Load workbook; create if not existing wb <- loadWorkbook("XLConnect.xlsx", create = TRUE) # Create a worksheet createSheet(wb, name = "mtcars") # Create a name reference createName(wb, name = "mtcars", formula = "mtcars!$C$5") # Write built-in data.frame 'mtcars' to the specified named region writeNamedRegion(wb, mtcars, name = "mtcars") # Save workbook saveWorkbook(wb)