XLConnect-package: Excel Connector for R

In XLConnect: Excel Connector for R

Excel Connector for R

Description

Provides comprehensive functionality to read, write and format Excel data.

Details

Package:	XLConnect
Type:	Package
Version:	0.2-15
Date:	2018-04-05
URL:	https://mirai-solutions.ch
	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")

Author(s)

Mirai Solutions GmbH, [e-mail]

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)

XLConnect documentation built on Feb. 16, 2023, 5:53 p.m.