GetNewXL: Create a New Excel Instance

Description Usage Arguments Details Author(s) See Also Examples

View source: R/DescTools.r

Description

Start a new instance of Excel and return its handle. This is needed to address XL afterwards.

Usage

1
GetNewXL(visible = TRUE)

Arguments

visible

logical, should Excel made visible? Defaults to TRUE.

Details

Here's a list of some frequently used commands.
Let's assume:

1
xl <- GetNewXL()
workbooks xl$workbooks()$count()
quit excel xl$quit()

Author(s)

Andri Signorell <[email protected]>

See Also

XLView, XLGetRange, XLGetWorkbook

Examples

1
2
3
4
5
## Not run:  # Windows-specific example
# get a handle to a new excel instance
xl <- GetNewXL()

## End(Not run)

DescTools documentation built on Sept. 13, 2017, 9:04 a.m.