Save Excel File

Save the current workbook under the given name and format.

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

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").

Value

returns TRUE if the save operation has been successful

Author

Andri Signorell <andri@signorell.net>

See also

XLView

Examples

if (FALSE) # Windows-specific example
XLView(d.diamonds)
XLSaveAs("Diamonds")
#> Error in xl[["ActiveWorkbook"]]$SaveAs(FileName = fn, FileFormat = file_format): attempt to apply non-function
xl$quit()
#> Error in eval(expr, envir, enclos): object 'xl' not found