Values for specifying a format for data you want to save.
Used in the SaveAs method for saving the data of a DataWindow, a graph control in a DataWindow, or a PowerBuilder graph control.
PowerBuilder enumerated value |
Web DataWindow |
Numeric value |
Meaning |
|---|---|---|---|
Excel! |
Excel |
0 |
Microsoft Excel format. |
Text! |
Text |
1 |
(Default) Tab-separated columns with a return at the end of each row |
CSV! |
CSV |
2 |
Comma-separated values |
SYLK! |
SYLK |
3 |
Microsoft Multiplan format |
WKS! |
WKS |
4 |
Lotus 1-2-3 format |
WK1! |
WK1 |
5 |
Lotus 1-2-3 format |
DIF! |
DIF |
6 |
Data Interchange Format |
dBASE2! |
dBASE2 |
7 |
dBASE-II format |
dBASE3! |
dBASE3 |
8 |
dBASE-III format |
SQLInsert! |
SQLInsert |
9 |
SQL syntax |
Clipboard! |
Clipboard |
10 |
Save an image of the graph to the clipboard |
PSReport! |
PSReport |
11 |
Powersoft Report (PSR) format |
WMF! |
WMF |
12 |
Windows Metafile format |
HTMLTable! |
HTMLTable |
13 |
HTML TABLE, TR, and TD elements |
Excel5! |
Excel5 |
14 |
Microsoft Excel Version 5 format |
XML! |
XML |
15 |
Extensible Markup Language (XML) |
XSLFO! |
XSLFO |
16 |
Extensible Stylesheet Language Formatting Objects (XSL-FO) |
PDF! |
17 |
Portable Document Format (PDF) |
|
Excel8! |
Excel8 |
18 |
Microsoft Excel Version 8 and higher format |
EMF! |
EMF |
19 |
Enhanced Metafile Format |
XLSX! |
— |
24 |
Microsoft Excel 2007 format for XML data (requires .NET Framework 3.0 or later) |
XLSB! |
— |
25 |
Microsoft Excel 2007 format for binary data (requires .NET Framework 3.0 or later) |
Obsolete values
The following SaveAsType values are considered to be obsolete
and will be removed in a future release: Excel!, WK1!, WKS!, SYLK!,
dBase2!, WMF!. Use Excel8!, XLSB!, or XLSX! for current versions
of Microsoft Excel!, and EMF! in place of WMF!.
Formats supported on UNIX The following formats are supported in PowerBuilder components deployed to the UNIX platform: Text!, CSV!, SQLInsert!, HTMLTable!, XML!, XSLFO!, and PDF!.
The following formats are not supported on UNIX: PSReport!, Excel!, Excel5!, Excel8!, SYLK!, WKS!, WK1!, DIF!, dBase2!, dBase3!, Clipboard!, WMF!, EMF!, XLSB!,and XLSX!.
Web DataWindow server component The Web DataWindow server component supports all formats listed in the table. In the Web DataWindow server-side SaveAs method, you can use a string value with or without the exclamation point to set the format for the data you want to save. For example, you could use CSV or CSV! to specify a format with comma separated values.
If a destination is not passed in the server-side SaveAs method, a file dialog box will not be put up on the server.
PSR format changed The format of PSR files created in PowerBuilder has changed in order to improve data integrity for the SaveAsAscii function. As a result, PSR files created in newer builds of PowerBuilder cannot be opened in builds that predate this change. This change was made in PowerBuilder 8.0 build 7063 and PowerBuilder 7.0.3 build 10102.
