SaveAs Method [Worksheet]
The SaveAs method saves the worksheet. Returns a Boolean.
Syntax
object.SaveAs( FileName, Options, FileFormat )
Parameter | Type | Description |
FileName | String | optional, default="", path and file name including the extension, if nothing is specified theFullNameproperty is used. |
Options | String | optional, default="" , used only with the worksheet document. If nothing is specified, the last option used to save the worksheet is used again. Golden Software Data [.DAT] and Microsoft Excel [.XLS] file formats contain options, see below. |
FileFormat | wksFileFormat | optional, default=wksFileFormatUnknown |
Remarks
See Golden Software Data Export Automation Options and Microsoft Excel Export Automation Options for information on worksheet export Options.
Example 1
This example shows how to save the worksheet to a DAT format.
Wks.SaveAs(GrapherApp.Path+"\Samples\savedfromscript.dat")
Example 2
This example shows how to save the worksheet to an XLSX format.
Wks.SaveAs(GrapherApp.Path+"\ Samples\savedfromscript.xlsx","",wksFileFormatXlsx)
Used by: Worksheet object