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

Description Usage Arguments Format Value Examples

View source: R/xl.constants.R

Description

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

Usage

1
2
3

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

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
## 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)

gdemin/excel.link documentation built on May 24, 2018, 9:31 p.m.