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 |
Numeric value |
Meaning |
|---|---|---|
|
Excel! |
0 |
Microsoft Excel format. |
|
Text! |
1 |
(Default) Tab-separated columns with a return at the end of each row |
|
CSV! |
2 |
Comma-separated values |
|
SYLK! |
3 |
Microsoft Multiplan format |
|
WKS! |
4 |
Lotus 1-2-3 format |
|
WK1! |
5 |
Lotus 1-2-3 format |
|
DIF! |
6 |
Data Interchange Format |
|
dBASE2! |
7 |
dBASE-II format |
|
dBASE3! |
8 |
dBASE-III format |
|
SQLInsert! |
9 |
SQL syntax |
|
Clipboard! |
10 |
Save an image of the graph to the clipboard |
|
PSReport! |
11 |
Powersoft Report (PSR) format |
|
WMF! |
12 |
Windows Metafile format |
|
HTMLTable! |
13 |
HTML TABLE, TR, and TD elements |
|
Excel5! |
14 |
Microsoft Excel Version 5 format |
|
XML! |
15 |
Extensible Markup Language (XML) |
|
XSLFO! |
16 |
Extensible Stylesheet Language Formatting Objects (XSL-FO) |
|
PDF! |
17 |
Portable Document Format (PDF) |
|
Excel8! |
18 |
Microsoft Excel Version 8 and higher format |
|
EMF! |
19 |
Enhanced Metafile Format |
|
XLSX! |
24 |
Microsoft Excel format for XML data (requires .NET Framework 4.0 or later) |
|
XLSB! |
25 |
Microsoft Excel format for binary data (requires .NET Framework 4.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!.
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.
See also
