DDE Formats

Microsoft Excel supports several DDE formats. The formats are listed in the following table in the order of precedence defined by Microsoft Excel, from highest precedence (XlTable) to lowest precedence (CF_METAFILEPICT). Clipboard formats that begin with CF_ are formats that are already defined in WINDOWS.H. Clipboard formats without CF_ must be registered before use. For more information about registering formats, see "Registering Clipboard Formats" on page 534.

Clipboard format

Description

XlTable

Microsoft Excel fast table format. For more information, see "Fast Table Format" on page 535.

Biff5

Binary interchange file format (BIFF) for Microsoft Excel version 5.0. For more information about the file format, see Chapter 9, "Microsoft Excel File Format."

Biff4

Binary interchange file format (BIFF) for Microsoft Excel version 4.0.

Biff3

BIFF for Microsoft Excel version 3.0.

Biff

BIFF for Microsoft Excel version 2.x.


Clipboard format

Description

CF_SYLK

Microsoft symbolic link (SYLK) format. Microsoft Excel for the Apple Macintosh was originally designed to use SYLK format, and this format is now supported by Microsoft Excel on both Windows and Macintosh platforms.

Wk1

Lotus 1-2-3 Release 2.01 and Release 2.2 formats.

Csv

Comma-separated values format, commonly used in BASIC language I/O. It is similar to CF_TEXT format, except that Csv uses commas to separate fields.

CF_TEXT

The simplest form of clipboard data. It is a null-terminated string containing a carriage return and linefeed at the end of each line.

Rich Text Format

A method of encoding formatted text and graphics for easy transfer between applications. Rich Text Format (RTF) is commonly used by document processing programs such as Microsoft Word for Windows and Microsoft Word for the Macintosh.

CF_DIF

An ASCII format used by the VisiCalc spreadsheet program. The format is under the control of Lotus Development Corporation.

CF_BITMAP

A Windows version 2 compatible bitmap.

CF_METAFILEPICT

A metafile picture structure. For complete information, see the documentation for the Microsoft Windows Software Development Kit.