Skip to Content

XLConnect-package {XLConnect}

Excel Connector for R
Package: 
XLConnect
Version: 
0.2-7

Description

Manipulate Excel files from R

Details

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

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)

Author(s)

Mirai Solutions GmbH, xlconnect@mirai-solutions.com

Documentation reproduced from package XLConnect, version 0.2-7. License: GPL-3