XLConnect-package {XLConnect} | R Documentation |
Excel Connector for R
Description
Provides comprehensive functionality to read, write and format Excel data.
Details
For an overview over the package please refer to the available demos:
demo(package = "XLConnect")
Author(s)
Mirai Solutions GmbH, xlconnect@mirai-solutions.com
References
Mirai Solutions GmbH: https://mirai-solutions.ch
XLConnect on GitHub: https://github.com/miraisolutions/xlconnect
Mirai Solutions on GitHub: https://github.com/miraisolutions
Apache POI: https://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")
## End(Not run)
[Package XLConnect version 1.0.10 Index]