DADiSP Worksheet Functions > Function Categories > ActiveX > Automation Client > XLSAVEAS
Save the current Excel Workbook to a specified file via ActiveX Automation.
XLSAVEAS("filename", format, verbose)
"filename" |
- |
A string. The name of the destination file. |
||||
format |
- |
Optional. An integer, the file format of the target file. Defaults to -1, native format (XLS). See below for a list of supported formats. |
||||
verbose |
- |
Optional. An integer, the message flag
|
A 1 if successful, else an error.
xlinit();
xlput("A1:C10", ravel(1..30, 10));
xlsaveas("C:\temp\test.xls");
xlclear();
The values 1..30 are shaped into a 10x3 array and written to cells A1 through C10. The Workbook is saved in XLS format to the file C:\temp\test.xls.
xlinit();
xlput("A1:C10", ravel(1..30, 10));
xlsaveas("C:\temp\test.csv", 6);
xlclear();
Same as the previous example except the file is saved to C:\temp\test.csv in CSV format.
XLSAVEAS connects to the running instance of Excel.
The format parameter specifies the file format. The following formats are supported:
Constant |
Value |
Description |
xlWorkbook |
-4143 |
Microsoft Excel Workbook |
xlHTML |
44 |
Web Page |
xlTemplate |
17 |
Template |
xlPlatformText |
-4158 |
Text (Tab Delimited) |
xlUnicodeText |
42 |
Unicode Text |
xlExcel5 |
39 |
Microsoft Excel 5.0/95 Workbook |
xlExcel7 |
39 |
Microsoft Excel 5.0/95 Workbook |
xlExcel9795 |
43 |
Microsoft Excel 97-2000 & 5.0/95 Workbook |
xlCSV |
6 |
CSV (Comma Delimited) |
xlExcel4 |
33 |
Microsoft Excel 4.0 Worksheet |
xlExcel3 |
29 |
Microsoft Excel 3.0 Worksheet |
xlExcel2 |
16 |
Microsoft Excel 2.1 Worksheet |
xl4Workbook |
35 |
Microsoft Excel 4.0 Workbook |
xlWK4 |
38 |
WK4 (1-2-3) |
xlWK3FM3 |
32 |
WK3, FM3 (1-2-3) |
xlWK3FM3 |
15 |
WK3 (1-2-3) |
xlWK1FMT |
30 |
WK1, FMT (1-2-3) |
xlWK1ALL |
31 |
WK1, ALL (1-2-3) |
xlWK1 |
5 |
WK1 (1-2-3) |
xlWKS |
4 |
WKS (1-2-3) |
xlWQ1 |
34 |
WQ1 (Quattro Pro/DOS) |
xlDBF4 |
11 |
DBF 4 (dBASE IV) |
xlDBF3 |
8 |
DBF 3 (dBASE III) |
xlDBF2 |
7 |
DBF 2 (dBASE II) |
xlTextPrinter |
36 |
Formatted Text (Space Delimited) |
xlTextMac |
19 |
Text (Macintosh) |
xlTextMSDOS |
21 |
Text (MS-DOS) |
xlCSVMac |
22 |
CSV (Macintosh) |
xlCSVMSDOS |
24 |
CSV (MS-DOS) |
xlDIF |
9 |
DIF (Data Interchange Format) |
xlSYLK |
2 |
SYLK (Symbolic Link) |
See XLSAVE to save to the original file.
See WRITETABLE to save a series as a single or multi-column table.