SaveAsType DataWindow constant
Description
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.
Values
|
PowerBuilder enumerated value |
Web DataWindow |
Numeric value |
Meaning |
|---|---|---|---|
|
Excel! |
Excel |
0 |
Microsoft Excel format. |
|
Text! |
Text |
1 |
(Default) Tab-separated columns with |
|
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 |
|
PDF! |
|
17 |
Portable Document Format (PDF) |
|
Excel8! |
Excel8 |
18 |
Microsoft Excel Version 8 and higher |
|
EMF! |
EMF |
19 |
Enhanced Metafile Format |
|
XLSX! |
— |
24 |
Microsoft Excel 2007 format for XML data |
|
XLSB! |
— |
25 |
Microsoft Excel 2007 format for binary |
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.