SaveAsType

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 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!.

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

SaveAs