XLConnect-package {XLConnect}
Excel Connector for R
Description
Manipulate Excel files from R
Details
| Package: | XLConnect |
| Type: | Package |
| Version: | 0.2-5 |
| Date: | 2013-03-18 |
| URL: | http://www.mirai-solutions.com |
| http://miraisolutions.wordpress.com | |
| SystemRequirements: | java (>= 6.0) |
| Depends: | R (>= 2.10.0), rJava, utils, methods |
| 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")
References
Mirai Solutions GmbH: http://www.mirai-solutions.com
Mirai Solutions Blog: http://miraisolutions.wordpress.com
Apache POI: http://poi.apache.org
Examples
# 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)
Documentation reproduced from package XLConnect, version 0.2-5. License: GPL-3