XLConnect-package

Excel Connector for R

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

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

Aliases

• XLConnect-package
• XLConnect

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