GetNewXL: Create a New Excel Instance

In DescTools: Tools for Descriptive Statistics

Create a New Excel Instance

Description

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

Usage

GetNewXL(visible = TRUE, newdoc = TRUE)

Arguments

visible	logical, should Excel made visible? Defaults to TRUE.
newdoc	logical, determining if a new workbook should be created. Defaults to TRUE.

Details

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

xl <- GetNewXL()

workbooks	xl$workbooks()$count()
quit excel	xl$quit()

Author(s)

Andri Signorell <[e-mail]>

See Also

XLView, XLGetRange, XLGetWorkbook

Examples

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

## End(Not run)

DescTools documentation built on Sept. 26, 2024, 1:07 a.m.