excel.link (version 0.9.13)

xl.property: Excel constants and helper function for setting Excel range properties.

Description

xl.constants is a list with (surprise!) Excel named constants.

Usage

xl.property(...)
xl.constants

Value

list of class xl.property.

Format

An object of class list of length 2024.

Arguments

...

names of arguments are properties as in Excel VBA, values are properties values.

Examples

if (FALSE) {
# create random matrix
rand_mat = matrix(runif(16), ncol = 4)

# put it on the new worksheet
xln[a1] = rand_mat 

# set bold font, format numbers as percent and align it
cr[a1] = xl.property(Font.Bold = TRUE, 
                     NumberFormat = "0.00%", 
                     HorizontalAlignment = xl.constants$xlCenter
                     )
}