XLConnect (version 1.0.7)

$-methods: Executing workbook methods in object$method(...) form

Description

Allows to execute workbook methods in workbook-object$method(...) form.

Arguments

x

The object (workbook, cellstyle) to use

Author

Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch

Details

x$method(...) (where x is a workbook-object) is equivalent to method(x, ...)

See Also

workbook

Examples

if (FALSE) {
# Load workbook (create if not existing)
wb <- loadWorkbook("dollar.xlsx", create = TRUE)

# Create a worksheet called 'CO2'
wb$createSheet(name = "CO2")

# Write built-in data set 'CO2' to the worksheet created above
wb$writeWorksheet(CO2, sheet = "CO2", startRow = 4, startCol = 2)

# Save workbook
wb$saveWorkbook()

# clean up 
file.remove("dollar.xlsx")
}