Excel Format

Excel format creates an xls file that can be opened in Microsoft Excel.

This example shows the five rows of data returned for a simple query MSGSET that has two columns. The SQL for this query is:

SELECT A.MESSAGE_SET_NBR, A.DESCR
  FROM PSMSGSETDEFN A

Example XLS File:

This example illustrates the fields and controls on the Excel format.