XLConnect-package
From XLConnect v1.0.1
by Martin Studer
Excel Connector for R
Provides comprehensive functionality to read, write and format Excel data.
- Keywords
- package
Details
Package: | XLConnect |
Type: | Package |
Version: | 0.2-15 |
Date: | 2018-04-05 |
URL: | http://www.mirai-solutions.com |
https://github.com/miraisolutions/xlconnect | |
BugReports: | https://github.com/miraisolutions/xlconnect/issues |
SystemRequirements: | Java (>= 6) |
Depends: | R (>= 2.10.0) |
Imports: | methods, rJava |
Suggests: | RUnit, lattice, ggplot2 (>= 0.9.3), zoo |
License: | GPL-3 |
Copyright: | See file COPYRIGHTS |
LazyData: | 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 XLConnect on GitHub: https://github.com/miraisolutions/xlconnect Mirai Solutions on GitHub: https://github.com/miraisolutions Apache POI: http://poi.apache.org
Examples
# NOT RUN {
# 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)
# clean up
file.remove("XLConnect.xlsx")
# }
Community examples
Looks like there are no examples yet.