Learn R Programming

DescTools (version 0.99.19)

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()
workbooks
xl$workbooks()$count()
quit excel
xl$quit()

See Also

XLView, XLGetRange, XLGetWorkbook

Examples

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

Run the code above in your browser using DataLab