powered by
Start a new instance of Excel and return its handle. This is needed to address the Excel application and objects afterwards.
GetNewXL(visible = TRUE, newdoc = TRUE)
logical, should Excel made visible? Defaults to TRUE.
TRUE
logical, determining if a new workbook should be created. Defaults to TRUE.
Andri Signorell <andri@signorell.net>
Here's a list of some frequently used commands. Let's assume:
xl <- GetNewXL()
xl$workbooks()$count()
xl$quit()
XLView, XLGetRange, XLGetWorkbook
XLView
XLGetRange
XLGetWorkbook
if (FALSE) # Windows-specific example # get a handle to a new excel instance xl <- GetNewXL()
Run the code above in your browser using DataLab