XLConnect (version 0.1-3)

XLConnect-package: Excel Connector for R

Description

Manipulate Excel files from R

Details

ll{ Package: XLConnect Type: Package Version: 0.1-3 Date: 2011-02-25 URL: http://www.mirai-solutions.com SystemRequirements: java Depends: R (>= 2.10.0), XLConnectJars (>= 0.1-0), XLConnectJars(<= 0.1-0),="" rjava,="" utils,="" methods="" suggests:="" runit,="" lattice="" license:="" gpl-3="" lazyload:="" yes="" }="" for="" an="" overview="" over="" the="" package="" please="" refer="" to="" available="" demos:="" demo(package = "XLConnect")

References

Mirai Solutions GmbH: http://www.mirai-solutions.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)