Learn R Programming

DescTools (version 0.99.57)

XLSaveAs: Save Excel File

Description

Save the current workbook under the given name and format.

Usage

XLSaveAs(fn, file_format = xlConst$XlFileFormat$xlWorkbookNormal, 
         xl = DescToolsOptions("lastXL"))

Value

returns TRUE if the save operation has been successful

Arguments

fn

the filename

file_format

the file format using the xl constant.

xl

the pointer to a MS-Excel instance. An new instance can be created with GetNewXL(), returning the appropriate handle. A handle to an already running instance is returned by GetCurrXL(). Default is the last created pointer stored in DescToolsOptions("lastXL").

Author

Andri Signorell <andri@signorell.net>

See Also

XLView

Examples

Run this code
if (FALSE) # Windows-specific example
XLView(d.diamonds)
XLSaveAs("Diamonds")
xl$quit()

Run the code above in your browser using DataLab