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

In excel.link: Convenient Data Exchange with Microsoft Excel

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

Arguments

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

Format

An object of class list of length 2024.

Value

list of class xl.property.

Examples

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

## End(Not run)

excel.link documentation built on Sept. 11, 2024, 5:18 p.m.