DescTools (version 0.99.16)

GetNewXL: Create a new Excel Instance

Description

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

Usage

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: xl <- GetNewXL() ll{ workbooks xl$workbooks()$count() quit excel xl$quit() }

See Also

XLView, XLGetRange, XLGetWorkbook

Examples

# Windows-specific example
# get a handle to a new excel instance
xl <- GetNewXL()