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

In XLConnect: Excel Connector for R

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

Details

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

Note

The workbook $-operator allows to call workbook-methods in workbook-object$method(...) form. This form might be considered more convenient or readable for programmers coming from other object-oriented languages such as Java, C#, ...

Author(s)

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

See Also

workbook

Examples

## Not run: 
# 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")

## End(Not run)

XLConnect documentation built on June 8, 2025, 10:15 a.m.